Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Get Updatecount in Stored Procedure

Get Updatecount in Stored Procedure

From: Sam Jordan <sjo_at_spin.ch>
Date: Wed, 02 Jun 1999 13:44:19 +0000
Message-ID: <37553532.F9032643@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 - 08:44:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US