"SET DEF OFF" option

[Kuba]

Is there any way to do something like "SET DEF OFF" (I'm using it in SQL*Plus) on SQL script (*.sql) or command file (*.pdc) executing. When in that file is for example:

create or replace procedure TEST(
p out varchar2
) is
begin

p := '

 

[Marco Kalter]

In the Command Window you can indeed use the SET DEF OFF command. In the SQL Window you will have to use a double ampersand instead (p := '&&lt').

------------------
Marco Kalter
Allround Automations

 

[Kuba]

Originally posted by mkalter:
In the Command Window you can indeed use the SET DEF OFF command. In the SQL Window you will have to use a double ampersand instead (p := '&