Need to store dbms_output lines on executing a procedure.

0
I can execute the procedure fine using database connector, however i do have few dbms output lines in the procedure that helps create another script based on the output lines. How do i obtain those into a variable for next steps ? what process can i follow ?
asked
1 answers
0

You may be able to get dbms output by wrapping your stored procedure call in an anonymous plsql block, where you use dbms_output.get_lines to get the lines, concatenate all lines and return these as the output.

 

Sample plsql code is in the oracle connector: https://github.com/ako/OracleConnector/blob/efdf613874e0a25db07d656a6073deacf65f530e/javasource/oracleconnector/impl/JdbcConnector.java#L110

 

You may also want to propose this as an idea for default functionality in the idea forum. We’ll consider it for the roadmap.

answered