1

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?

Cœur
  • 37,241
  • 25
  • 195
  • 267
Keith
  • 11
  • 2

1 Answers1

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.

Tony Andrews
  • 129,880
  • 21
  • 220
  • 259