CODEWITHSUNDEEP
vb.netplsqloracle11gdbms-output
Keith
Keith

Reputation: 11

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

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?

Upvotes: 1

Views: 1082

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132570

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.

Upvotes: 1

Related Questions