Home » Developer & Programmer » Precompilers, OCI & OCCI » Declare Cursor error in pro*c
Declare Cursor error in pro*c [message #94228] Mon, 24 May 2004 15:15 Go to next message
sundar
Messages: 23
Registered: May 2001
Junior Member
Hi All,

I've prepared a SQL stmt and declared the cursor in function, and i'm trying to open the cursor in a different function. However, both functions are in same .pc file. While opening the cursor it says

Semantic error at line 368, column 24, file rating_commit_load.pc:
         EXEC SQL OPEN ttl_ss_parts_curs
.......................1
PCC-S-02334, SQL identifier was not declared as a cursor

I've verified the cursor name, there is no name mismatch. Can some throw some light on this.

Thanks and Regards
Sundar.

 
Re: Declare Cursor error in pro*c [message #94287 is a reply to message #94228] Wed, 30 June 2004 05:02 Go to previous message
Jai Vrat
Messages: 20
Registered: June 2004
Junior Member
Can you please confirm the scope of the cursor. Like varibales they also have got scope.
Previous Topic: ORA-21301: not initialized in object mode
Next Topic: Oracle OCI8 fetch of nvarchar2 column returning no data
Goto Forum:
  


Current Time: Fri Mar 29 05:55:54 CDT 2024