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: 2844
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: 64502
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: Wed Mar 01 14:17:28 CST 2017

Total time taken to generate the page: 0.10131 seconds