OraFAQ Forum: SQL & PL/SQL » dbms

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_output to VB (URGENT)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_output to VB (URGENT) [message #39266]

Tue, 02 July 2002 05:38

ranjan
Messages: 20
Registered: August 1999

Junior Member

Hi I have created a procedure in which I have written dbms_output.put_line('Test');
Now I want this output from dbms_output.put_line to be captured through VB. Is there anyway to do this.

Ranjan...

Report message to a moderator

Re: dbms_output to VB (URGENT) [message #39267 is a reply to message #39266]

Tue, 02 July 2002 05:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

dbms_output.put_line is used only to display the output in sql*plus.
u need to use OUT parameters in stored procedure to capture the output from the stored procedure

Report message to a moderator

Re: dbms_output to VB (URGENT) [message #39270 is a reply to message #39266]

Tue, 02 July 2002 11:08

andrew again
Messages: 2577
Registered: March 2000

Senior Member

you can call dbms_output.get_lines but I'd strongly advise against it. Mahesh is right.

Report message to a moderator

Previous Topic:	ORDER BY causing Performance problems
Next Topic:	How to do SELECT MAX with NON NULL VALUE but 1 to default

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 11:40:02 CDT 2024