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