how to refresh cursor-values in pl/sql

[mokesql]

hey!
is it possible to refresh cursor-values during a pl/sql procedure. my problem is that at the declaration time of the cursror there is no date in the table where the cursor should take his date from. but during the procedure i fill the table and then i want this date in the cursor. is there a possibility of that? please help me as quick as possible, thnx

kemo

 

[rcurva]

If I understand you right, you wish to update a table included in the cursor you are currently looping and expecting the cursor values updated as well. This is not possible, because a cursor is a work area once opened, executes the query associated with the cursor, identifies the result set, and positions the cursor before the first row. The result set will then consist of rows with the conditions before the cursor opened.

Can you post your original script/procedure to better understand your requirements?

 

[sem]

You may open cursor as many times as you wish (don't forget to close it if already opened).
Your declaration does not matter, the data is fixed while opening, not declaring.