Re: How to get "number_of_affected_rows" after "insert ... select..."

You can use SQL%ROWCOUNT immediately following the insert, update or delete statement and get the number of rows affected by the SQL command.

Kenny

gmei_at_my-deja.com wrote in message <7vvgfb$8kp$1_at_nnrp1.deja.com>...
>Hi:
>
>I have a procedure in an oracle package which does something like
>
>insert into table1
>(col1,
>col2)
>select
>val1,
>val2
>from tableA
>where tableA.colA = 'something';
>
>This can insert more than one rows in table1, I want to know how many
>rows inserted in table1 without doing another "select count(*) .." query
>so I can determine if the sql runs successfully.
>
>Is there a "global" variable in oracle which will return the
>"number_of_affected_rows" after an executed sql statement?
>
>I am not using dynamic sql and I thought "RETURNING" clause only can
>return single row.
>
>Any suggestions?
>
>Thanks.
>
>Guang
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 05 1999 - 15:45:28 CST