This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes printing to server console Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "printing to server console" Watch "printing to server console" New topic

printing to server console

Daniel Conner
Ranch Hand

Joined: Jan 25, 2007
Posts: 47
I have a couple Oracle SQL procedures that I am working on that I am calling from a JSF web application. For testing purposes I would like to output certain values to my server console. Is there a way to use


where I can see the output on the server console? I am using oracle application server and my database server is oracle 10g. Let me know. Thanks.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You don't have direct access to the buffer unless you are running a procedure in SQL*Plus. You can read what is on the buffer via the GET_LINE function, however this is not a very nice way to do debugging (one of the extra complication if you use Stored Procedures in you application). I'd work on the procedures in isolation, then try using them through your web application once you are confident they work as you expect.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Consider Paul's rocket mass heater.
subject: printing to server console
It's not a secret anymore!