Re: Get Updatecount in Stored Procedure

If you used dbms_sql, i *think* it returns the number o rows inserted/updated. This could be returned to your program.

M

Sam Jordan wrote in message <37553532.F9032643_at_spin.ch>...
>Hi
>
>I have a stored procedure which updates a table. How can I find out
>whether the update was successful or whether zero rows were inserted?
>SQLPlus usually prints out the amount of rows updated. I would like
>to get a similar information in my stored procedure.
>
>I'm using Oracle 8.0.5 for Linux.
>
>bye
>--
>Sam Jordan
Received on Wed Jun 02 1999 - 09:08:49 CDT