Home » Developer & Programmer » Precompilers, OCI & OCCI » Using Cursor in ProCobol
Using Cursor in ProCobol [message #478312] Thu, 07 October 2010 16:34 Go to next message
idiazr
Messages: 4
Registered: October 2010
Location: Colombia
Junior Member
In a Cobol prgram (ProCobol )

I declare a cursor for a tbale with 8000 records, when I fetch the cursor this message apear ORA-03113: end-of-file on communication channelm when the fetch reach the 6500 element, What is the problem here?. All data are ok, not null fields.

other problem

How I can reuse a cursor, I declare a cursor for a table where code_part = 300, then I fetch all elements until end cursor, then I close the cursor, Then I declare the same cursor again for the same table where code_part = 359, but it is not succesfull, when I tried to fetch the cursor again the cobol program show me the last record for the first code, How I can restart the cursor or delete it or freed the cursor position?

Thank you
Re: Using Cursor in ProCobol [message #478350 is a reply to message #478312] Fri, 08 October 2010 02:51 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel
Previous Topic: Passing array of structure to oracle procedure and returning back.
Next Topic: connect from incide c program
Goto Forum:
  


Current Time: Thu Mar 28 06:30:24 CDT 2024