nested select problem -
07-11-2008
, 08:20 AM
I have a statement that executes in SQL*Plus but not within Pro*C.
I'm guessing it has to do with where the nested select is (I know it
works from the where clause)
SELECT foo, (SELECT bar from baz where id = 1) FROM table1 WHERE ....
Pro*C does not like the "SELECT bar". Can I not place nested selects
in this part of my statement when compiling with Pro*C? |