Hi folks,
Okay, I looked at the issue a big more carefully with some trial and error.
Try out the package code below. It crashes TOAD every time for me.
Thanks,
Paul
CREATE OR REPLACE PACKAGE testcondcomp
AS
FUNCTION packagecondcomp(
p_input IN VARCHAR2
) RETURN CLOB;
END TESTCONDCOMP;
/
CREATE OR REPLACE PACKAGE BODY testcondcomp
AS
FUNCTION packagecondcomp(
p_input IN VARCHAR2
) RETURN CLOB
AS
str_yada VARCHAR2(4000) := UPPER(p_input);
BEGIN
str_yada := SUBSTR(
'dog ’
$if dbms_db_version.ver_le_10 $then
|| 'cat ’
$else
|| 'goat ’
$end
|| 'hamster ',1,20);
RETURN str_yada;
END packagecondcomp;
END TESTCONDCOMP;
/
This email was scanned by MessageLabs