views:

28

answers:

0

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