Programming

I'm running a query similar to the one that I'm describing below -:
_______________________________
EXEC SQL INSERT INTO TABLE1
( C1
,C2
,C3
,C4 )
(SELECT DISTINCT B.V1
,B.V2
,( SELECT D.V3 FROM TABLE2 D WHERE D.V3 = C.V4)
,B.V4
FROM TABLE2 B ,TABLE3 C
WHERE B.V3 = C.V4) ;
_________________________________
Above query runs perfectly on SQL prompt.
Same query, when being run in a Pro*C program
gives compilation error-:
Error at specified line
,( SELECT D.V3 FROM TABLE2 D WHERE D.V3 = C.V4)
.............................1
PCC-S-02201, Encountered the symbol "D" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
_____________________________________
What are the possbile causes of error. I am using Oracle 10g on Unix. Help needed urgently.
Thanks a lot!

The Pro*C precompiler uses a different parser than does sqlplus. This happens every once in a while - the best work around is reformulate the query.

You can try changing the sqlcheck setting of Pro*c to be full, but you have to supply a username/password as well eg: userid=username/password.