I have a stored procedure that was written by a contractor over a year ago, but it was never exercised until now, and it’s not behaving as expected. Since the contractor is no longer employed here, and I wrote the original DB2 stored procedure from which it was converted, I’m being called in to diagnose the problem. I apologize for my inexperience with Oracle, but I’ve been a DB2 developer and DBA for the last few decades.
I've added some debug-lines to the stored procedure, but they don't appear to show up when I run the proc in SQL Developer.
They’re really simple debug-lines, such as these:
DBMS_OUTPUT.PUT_LINE('Beginning the Proc' );
DBMS_OUTPUT.PUT_LINE(sql%rowcount || ' rows inserted into Table1');
DBMS_OUTPUT.PUT_LINE(sql%rowcount || ' rows deleted from Table2');
But, when I run the procedure, it finishes "correctly" without printing these lines anywhere that I can see. I made sure to put one at the very beginning of the procedure, so I'm absolutely sure it will be reached, but I don't even see that one in the output. I would speculate that the debug-lines are showing up somewhere I'm not looking.
So, what am I missing?
Thanks for your help!