How to run SQL that contains bind variables in the ODT Query Window?
- by dnorthut
How do you run SQL that contains one or more bind variables in the Oracle Developer Tools for Visual Studio Query Window?
For example, the following works fine in SQL*Plus:
variable x NUMBER;
BEGIN
:x := 0;
END;
/
SELECT 1 FROM DUAL WHERE :x <> 1;
When executed in the ODT Query Window, the following exception is raised in the Query output pane:
ERROR
ORA-01008: not all variables bound
