Oracle Stored Procedure - Capturing serveroutput

[johnshot]

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

[johnshot]

never mind all! figured it out!
put dbms server output into a variable and passed
out with the output argument, then wrote it to the log.