another rookie Oracle question

Greetings, experts!

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!
DaveSlash
LVL 18
Dave FordSoftware Developer / Database AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
There is a dbms_output panel.  If that is visible and still no output then you need to enable dbms_output.

Either with:
set serveroutput on from the sql worksheek

DBMS_OUTPUT.ENABLE in the code


Here is a previous question where I added pretty pictures:
http://www.experts-exchange.com/questions/28696172/Having-trouble-writing-to-Dbms-Output.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave FordSoftware Developer / Database AdministratorAuthor Commented:
Once again, you've nailed it, slightwv !

From SQL Developer, I selected "View" : "Dbms Output" and clicked on the green plus-sign in the resulting Dbms Output window. Then, when I run the stored procedure, I can see the debug-lines.

Thanks!
slightwv (䄆 Netminder) Commented:
Always glad to help.

Even better when the answer was something from just a few days ago...  ;)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.