Toad World® Forums

Re: TOAD 10.5.1.3 not liking conditional compilation statements


#1

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



#2

It’s been fixed in the current 10.6 beta.

Michael


#3

I can reproduce this error in 10.5.1.3, but not in the 10.6 beta. It looks like
the newer version of QP5.dll has fixed this issue.