Home » Developer & Programmer » Precompilers, OCI & OCCI » Compilation error when compiling Pro*C code (merged)
Compilation error when compiling Pro*C code (merged) [message #395668] Thu, 02 April 2009 03:27 Go to next message
maheshp
Messages: 1
Registered: April 2009
Junior Member
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!
Re: Compilation error when compiling Pro*C code [message #396564 is a reply to message #395668] Tue, 07 April 2009 04:00 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
maheshp wrote on Thu, 02 April 2009 10:27
I'm running a query similar to the one that I'm describing below -:



That's the problem when you post "a similar query" : we can never be sure that you'll encounter the same error with this "similar query".
I'm afraid you're going to have to post the original query.

Use the code tags to make it a bit readable for us Wink



Previous Topic: Proc compiling error on Oracle 10g....Please help
Next Topic: Pro*C and PL/SQL question
Goto Forum:
  


Current Time: Thu Mar 28 18:00:13 CDT 2024