| Cursor [message #79334] |
Mon, 27 May 2002 05:58  |
shiva
Messages: 38
Registered: March 2001
|
Member |
|
|
|
I have a button which invokes a stored procedure where i have a cursor which fetches 50000 records and which updates to other table.The process is taking a long time to complete.Is there any way i can see how many records have been updated.
|
|
|
|
| Re: Cursor [message #79337 is a reply to message #79334] |
Mon, 27 May 2002 07:36  |
N
Messages: 26
Registered: April 2002
|
Junior Member |
|
|
hi,
when would you like to know how may records have been upd.
1. whilst the cursor is running, for this you could use SQL%ROWCOUNT and message out the var when finished
2. likewise if you need a running total include the var sql%rowcount in a loop in your cursor.
declare
v_count number;
update record;
sql%rowcount
message('Recs updated so far'||'-->'||v_count);
I think this is what u mean ?
Cheers
n.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
