Need to store dbms_output lines on executing a procedure.

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 ?
1 answers

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:


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