Oracle Stored Procedure - Capturing serveroutput
Posted: Mon Mar 20, 2006 3:51 pm
Hello all -
I am using the oracle stored procedure stage to build partitions based on passed arguments.
This all works fine, but I am unable to capture the
server output (the procedure makes calls to DBMS_OUTPUT.PUT_LINE('Partition not created');). (as an example).
Can anyone help me out?
Is there a way to capture generated output message(s) from the stored procedure stage easily?
Or do I have to use the raise_application_error code to achieve this?
And how specifically would I do that?
Wait until the procedure is complete and then raise an error anyway?
The objective is to pass informational messages back and capture without raising an error (warning) in the log.
As usual the datastage help doesn't have anything to say regarding this that I could find.
Thanks in advance
j schatz
I am using the oracle stored procedure stage to build partitions based on passed arguments.
This all works fine, but I am unable to capture the
server output (the procedure makes calls to DBMS_OUTPUT.PUT_LINE('Partition not created');). (as an example).
Can anyone help me out?
Is there a way to capture generated output message(s) from the stored procedure stage easily?
Or do I have to use the raise_application_error code to achieve this?
And how specifically would I do that?
Wait until the procedure is complete and then raise an error anyway?
The objective is to pass informational messages back and capture without raising an error (warning) in the log.
As usual the datastage help doesn't have anything to say regarding this that I could find.
Thanks in advance
j schatz