INSERT inside plsql procedure does not show how many rows have been inserted

Question

I am trying to insert some lines and update some lines inside a pl / sql loop.

however all I can see is the pl / sql procedure completed successfully.

I can see dbmbs_ouput instructions, but not the output status of insert and / or update requests.

serveroutput is set to on.

how can i see the status of the insert and update rows (namely how many rows have been inserted and updated)

+1

Kazoom 09 nov. 10 at 23:54

1 answer

Quassnoi · Accepted Answer · 2010-11-10T00:09:44+0000

Oracle rowcount

does not automatically output as it does in SQL Server

.

You have to do it explicitly:

BEGIN
        INSERT
        INTO    mytable
        SELECT  …
        FROM    other_table;
        DBMS_OUTPUT.put_line(SQL%ROWCOUNT);
END;