Hi Experts,
I have a stored procedure for which I want to write into a log table the actual number of rows inserted for later auditing if needed.
Howeever,
var_year is a parameter
but the error is thrown at SQL%ROWCOUNT, saying the symbol is not recognized.
INSERT INTO T_LOG (var_Year, time,message) VALUES (year, SYSDATE, TO_CHAR(SQL%ROWCOUNT)||' xxxxx '||VAR_year||' inserted');
Any ideas?