nested select problem

From: Brandon <>
Date: Fri, 11 Jul 2008 06:20:36 -0700 (PDT)
Message-ID: <>

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? Received on Fri Jul 11 2008 - 08:20:36 CDT

Original text of this message