Re: .sql file

Dear sappi,

after processing a Statement (update, delete etc.) in pl/sql, you can get the number of rows with:

select sql%rowcount into <variable> from dual;

Then: dbms_output.put_line ('inserted ' || <variable> || ' rows successfully.');

Best regards

roy Received on Tue May 09 2006 - 02:12:27 CDT