defines in sql scripts don't work

[Francky]

I used to work with SQl Navigator as a development tool. Recently I made the switch to PL/SQL Developer. Some of my sql-scripts do not longer proper work in PSD, typically it are scripts which use 'define'

for instance :

define inputvar1 = 'MAIN' -- default value
define inputvar2 = '' -- range of possible values
define inputvar3 = '' -- comment

begin

MyPackage.MyProcedure( p_input1 => '&inputvar1'
,p_input2 => '&inputvar2'
,p_input3 => to_date(nvl('&inputvar3', to_date(sysdate,'DD-MM-RRRR')),'DD-MM-RRRR');

end;

In Sql Navigator , the variables get the values of the defines , in PSD the variables stay blank...

Can this be solved with some (preference)settings ? Or is 'define' not supported in PSD ?

 

[June]

Hi,

I think you need to run these scripts in a command window (rather than a SQL window). Define is a SQL*Plus command, and the command window accepts those.