Re: Return value of dynamic SQL!

From: Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de>
Date: Mon, 19 Jul 1999 11:31:39 +0000
Message-ID: <37930C9B.7193BBAE@ibsgmbh.de>

Yeung Man wrote:
>
> Hi,
>
> We use 7.3.4.2 on digital Unix. Now, suppose sql = 'update tabA where
> pk_ind ='XXX', we then return_value = DBMS_SQL.EXECUTE(sql);. Then, we want
> to know what return_value can we get? How can we determine the sql is
> success, fail or not row updated?
>
> TIA.
>
> Best Regards,
> Man

Hello,

checkout $ORACLE_HOME/rdbms/admin/dbmssql.sql. You will find a briefly function description. The returnValue of execute is the number of rows affected by an insert, update or delete statement. If this is 0 the checkout sqlcode.

Regards

Michael Received on Mon Jul 19 1999 - 06:31:39 CDT