When I run a query with a bind variable set by a DEFINE statement in SQL Navigator 6.1, I get the error: "ORA-00936 missing expression."
For example:
DEFINE x= (<int1>,<int2>,<int3>,... etc);
SELECT column_id FROM schema.t WHERE column_id in &&x;
column_id is of type INTEGER for this example.
This use to work in SQL Nav 5.5.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center