How to run SQL that contains bind variables in the ODT Query Window?
Posted
by dnorthut
on Stack Overflow
See other posts from Stack Overflow
or by dnorthut
Published on 2010-06-09T21:40:23Z
Indexed on
2010/06/09
21:42 UTC
Read the original article
Hit count: 285
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
© Stack Overflow or respective owner
