Home » Developer & Programmer » Forms » Cursor
Cursor [message #79334] Mon, 27 May 2002 05:58 Go to next message
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 Go to previous message
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.
Previous Topic: How to create an EXE
Next Topic: ON ERROR (IS NIK AROUND?)
Goto Forum:
  


Current Time: Thu May 23 05:19:14 CDT 2024