DSXchange

Hello All,

I want to catch the user defined exceptions in a PL-SQL procedure and display them on Director logs, I am using a Stored procedure stage to trigger the PL-SQL code. Can this be done in datastage? Need help in this regards.

Thanks
Gokul

No, because you're not doing it in DataStage.

You are using a stored procedure to trigger the PL/SQL. This is too far removed from DataStage. You could always follow it up with DataStage; to have DataStage to read wherever it is that you've had the PL/SQL dump its messages.