OraFAQ Forum: Precompilers, OCI & OCCI » Using Cursor in ProCobol

Home » Developer & Programmer » Precompilers, OCI & OCCI » Using Cursor in ProCobol

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using Cursor in ProCobol [message #478312]

Thu, 07 October 2010 16:34

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

Report message to a moderator