Home » SQL & PL/SQL » SQL & PL/SQL » How to get the output of SQL%ROWCOUNT inside a procedure to the spool file.
icon4.gif  How to get the output of SQL%ROWCOUNT inside a procedure to the spool file. [message #413559] Thu, 16 July 2009 07:37 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Hi All,

How to get the output of SQL%ROWCOUNT inside a procedure to the spool file.

regards,
Nataraj.
Re: How to get the output of SQL%ROWCOUNT inside a procedure to the spool file. [message #413562 is a reply to message #413559] Thu, 16 July 2009 07:43 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
dbms_output
Re: How to get the output of SQL%ROWCOUNT inside a procedure to the spool file. [message #413563 is a reply to message #413559] Thu, 16 July 2009 07:45 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Trick question? There is no spool command in a procedure. That is a SQL*Plus command only.
Re: How to get the output of SQL%ROWCOUNT inside a procedure to the spool file. [message #413567 is a reply to message #413563] Thu, 16 July 2009 08:04 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

For eg.

spool PKGPATCH9.log

exec update_osfi;

spool off;

Ihave update statement in the procedure.

regards,
Nataraj
Re: How to get the output of SQL%ROWCOUNT inside a procedure to the spool file. [message #413569 is a reply to message #413562] Thu, 16 July 2009 08:19 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Thu, 16 July 2009 13:43
dbms_output

Previous Topic: Very new to SQL... syntax error problem
Next Topic: How to read a tab delimete file and load in to table using utl_file package
Goto Forum:
  


Current Time: Sat Dec 03 10:08:31 CST 2016

Total time taken to generate the page: 0.05773 seconds