Where is console output sent (System.out/System.err) in stored procedures written in Java?
I have a Stored procedure, which consists of the following: • Creating a Temp Table • Inserting Records to that • Do some more modifications.. • Creating Cursors • Some Select Statements… Moreover, my pocedure has a output parameter. I try to execute this procedure through CallableStatement, then I execute by calling the execute() method. When I process this using getMoreResults() & I am getting only update count, not my output parameter.
Related Questions
- Ryan Gaffuri asked: In our shop, the Java developers do not want to use any database stored procedures and only put logic in the middle tier. Is this a good idea?
- Where is console output sent (System.out/System.err) in stored procedures written in Java?
- How do I get java console output in case of applet failure?"