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
How to catch User Defined exceptions(PL-SQL) in Director Log
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.