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?
 
sdstuberConnect With a Mentor Commented:
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
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.