GeeCON Prague 2014*
The moose likes JDBC and the fly likes Refresh Cursor in Stored proc Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Refresh Cursor in Stored proc Oracle" Watch "Refresh Cursor in Stored proc Oracle" New topic
Author

Refresh Cursor in Stored proc Oracle

fahad siddiqui
Ranch Hand

Joined: Jun 14, 2006
Posts: 85
I have a stored procedure in which i define a cursor in the start like so:


After this, i iterate the loop and upon some conditions, i change the ACTIVE_STATUS and ERROR_FLAG to different values. Upon such an updation, that record should get erased from my cursor.
Hence, after the loop completes, i want to refresh my cursor, so that all such records which i updated during the loop, should now not be present in the cursor anymore.

Please advise urgently. I am using Oracle 8i.
Thanks in advance.
 
wood burning stoves
 
subject: Refresh Cursor in Stored proc Oracle