Hi,
Is there a way to display the output of a DML statement executed within a stored procedure or a PL/SQL block?
For example, consider the following PL/SQL block
BEGIN
DELETE FROM TABLE_1;
END;
I want to display the output of that DML statement like "2 rows deleted". I not looking for just the number of rows, I want the whole text message to be displayed. Also my requirement is not limited to just a delete statement but includes other DML statements as well like - ALTER INDEX, TRUNCATE etc.