This content has been marked as final. Show 1 reply
I would like to read the output from the P_Test and display in front end application.
is it is possible to read if the output is as dbms_output.put_line or the stored procedure needs to modify here with out parameter or ref-cursor.
Sure - first you need to enable DBMS_OUTPUT and then you need to actually go get it.
The procedure calls to methods such as PUT_LINE do nothing more than put text into a buffer. It is up to a client application to get the lines FROM the buffer.
Here is an AskTom blog that shows how to do that using Java - it is too lengthy to copy here.