Hi,
Can we call a Oracle Stored procedure in Job sequences .
Call stored procedure in Sequence
Moderators: chulett, rschirm, roy
Call stored procedure in Sequence
Thanks
Sheema
Sheema
In other words, a scripted call to sqlplus with the script launched by the Execute Command stage. Make no assumptions about the runtime environment and ensure it works outside of DataStage first, then add it to your Sequence. Also make sure errors are properly reported back from your proc to sqlplus to the script and lastly passed back to DataStage from the script's exit status - otherwise when it fails your Sequence job will have no clue.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 12
- Joined: Thu Sep 20, 2007 2:22 pm