aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Print Oracle DBMS_OUTPUT in Java, HOW? Help Please! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Print Oracle DBMS_OUTPUT in Java, HOW? Help Please!" Watch "Print Oracle DBMS_OUTPUT in Java, HOW? Help Please!" New topic
Author

Print Oracle DBMS_OUTPUT in Java, HOW? Help Please!

Bo Lin
Greenhorn

Joined: Nov 17, 2002
Posts: 6
Hello, I have a stored procedure/trigger in oracle that does something like:
dbms_output.put_line("hello world")
dbms_output.put_line("bla bla")

Now I am using Java/JDBC to access this oracle stored procedure/trigger and want to display the dbms_output ("hello world" "bla bla") etc within the Java GUI. How do i do that? Any help will be greatly appreciated, thank you.
Bo
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

The answer is - U cannot.


Groovy
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

you can't print directly from the procedure as stated earlier, but you can save the message as a VARCHAR in the procedure and return it as an out parameter. In java you can read the out parameter and System.out.println() the return message.
Jamie
 
Don't get me started about those stupid light bulbs.
 
subject: Print Oracle DBMS_OUTPUT in Java, HOW? Help Please!