Hey, I'm calling an Oracle stored procedure from .NET using
OracleCommand.ExecuteNonQuery(). Everything runs appropriately, but
the stored procedure does not use output parameters, but rather uses
DBMS_OUTPUT.PUT_LINE several times so that in sqlplus you get all
sorts of good info. I'm trying to figure out how to read the
serveroutput within .NET to get this info.
I've tried using the OracleInfoMessageEventHandler, but I'm either
doing it wrong or it's the wrong approach. The description states
that it: "Occurs when Oracle sends a warning or an informational
message"
Any suggestions?
Thanks in advance,
Matt