How to catch User Defined exceptions(PL-SQL) in Director Log

Gokul · Post by **Gokul** » Thu Mar 27, 2008 4:53 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 5:47 am

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.