How do I retreive Oracle DBMS_Output from a vb.net application

Question

I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code?

Answer 1

Provided the code executes in the same database session you can use DBMS_OUTPUT.GET_LINE (or GET_LINES). If it doesn't then you can't access it.