ORA-01008 Dynamic binding Variable

[mippeuda]

hi~~~

i excute that below statement in SQL window.

select * from dual where 1 = :var
;

pl/sql developer announce "ORA-01008 not all variables bound"

i want use colon) operator and avoid &(amp) operator
please explain the solution.

env is
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
wxp sp3
PL/SQLDeveloper 7.1.0.1337

 

[Marco Kalter]

You cannot use bind variables in the SQL Window. You can either:

1. Run this in the Test Window and declare the bind variable.

2. Run this in the SQLWindow and use a substitution variable (&var).

 

[Robertas]

is there possibility to switch off &var functionality?

if i try to execute this query i get prompted to enter variables
but there are no variables
select extractvalue(xmltype('bla'), 'root')
from dual

 

[Marco Kalter]

To escape variable substitution in the SQL Window, use && instead of &:

select extractvalue(xmltype('&bla&'), 'root')
from dual

 

[patch]

Or, if you use a command window issue the 'SET DEFINE OFF' command before you issue the query.
Regards,
Patrick

 

[Robertas]

Thank you for solution, but i would like to make a request for some sort of option to switch it of. It would be very annoying to replace characters in larger XML or some text.

Thank you