Need to see the output of dbms_output, using VB application

Hi guys,

Some wrote a pl/sql procedure, using dbms_output to debug, now we promoted them to PROD, these dbms_output statements are still there in the code.

Q1. is there any performance issue, having these statements still in code, while they are there in PROD.

Q2. these procedures have been called by VB application in PROD, now what we are looking for, is there any way to capture those errors which may be raised, there in PROD, but some weird work done by this VB application, what we are looking for is to see those errors or whatever be the output of these dbms_output.

Please clarify, if need be.

Thanks in advance.
Regards.
EL
el123Asked:
Who is Participating?
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.

sdstuberCommented:
Q1: yes, You are adding extra work to your processing. It's a small increment but if you are in a tight loop those extra small increments can add up. Also note in 9i dbms_output has a limit of 1,000,000 characters. So you can have a fatal error if you exceed the output limit

Q2: you can call dbms_output.get_line to retrieve anything written to your session's output buffer.
0

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
el123Author Commented:
thanks, but need to extract from VB application, it is been called by VB, no pl/sql any more, is there any way we can retrieve the info generated by dbms_output, and presented using VB apps?
0
slightwv (䄆 Netminder) Commented:
dbms_ouptut is used for debugging purposes only. I don't know of any way to retrieve them from a VB app.

You will either need to add the text to the error message if it is a raised event or create an output parameter for the procedure.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sdstuberCommented:
vb, by itself can't pull the dbms_output data.  You will have to use the dbms_output.get_xxxxx  procedures.

sorry
0
el123Author Commented:
thanks PAQ_Man
0
rsomasundarCommented:
As per this scnerio, dbms_output statements might be used in prod for debugging purpose or to maintain a log. But, It always best to keep those as results in seperate log file in database itself. So, it is recommended to remove those lines from prod.
0
el123Author Commented:
haven't got the answer to my question ... what should I do?
you can delete if you want
0
sdstuberCommented:
what answer are you looking for?


dbms_output.get_xxxxx  procedures allow you do to what you are looking for.

If you're looking for an answer like "use vb function  xyz"  sorry, doesn't exist, you'll have to write that function
0
slightwv (䄆 Netminder) Commented:
>>haven't got the answer to my question ... what should I do?

http://www.experts-exchange.com/help.jsp#hs=29&hi=405
The correct answer to some questions is "You can't do that."
0
el123Author Commented:
partially ;-)
0
sdstuberCommented:
what did you want to earn an A?
0
slightwv (䄆 Netminder) Commented:
Can I ask why you accepted the answer you did when that post requires PL/SQL to work?

The suggestion I posted in http:#28994639 would have allowed VB to process the output.
0
el123Author Commented:
need to close it ... that was the only accepted option, nothing else ... that's why
0
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.