Home » SQL & PL/SQL » SQL & PL/SQL » how to clear sql%rowcount value (pl/sql)
how to clear sql%rowcount value [message #398525] Thu, 16 April 2009 09:40 Go to next message
tamil
Messages: 22
Registered: April 2007
Location: chennai
Junior Member
hi,
i've using sql%rowcount sql cursor attributes and first time execution is successfully but when i execute next time the value is shown in same of first time execution value.

how to clear sql%rowcount value when i execute frequently.
please help me

thanks in advance
Re: how to clear sql%rowcount value [message #398526 is a reply to message #398525] Thu, 16 April 2009 09:55 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
SQL%ROWCOUNT shows the number of rows affected by the last DML statement. You do not write to it.
Re: how to clear sql%rowcount value [message #398527 is a reply to message #398525] Thu, 16 April 2009 09:56 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe because it is the same value.
rowcount is reinitialized each time you execute a sql call.

Regards
Michel
Previous Topic: Query performance in prod environment
Next Topic: Horizontal to Vertical Transpose.
Goto Forum:
  


Current Time: Tue Dec 06 11:56:13 CST 2016

Total time taken to generate the page: 0.16543 seconds