I tried it using CALL ProcedureName, but it is giving me error: ORA-06576: not a valid function or procedure name. This procedure is working fine at oracle side. I even tried all the suggestions menioned on here.
Any other siggestion?
Search found 3 matches
- Wed Feb 29, 2012 3:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: call oracle stored procedure in datastage server job
- Replies: 8
- Views: 7553
- Wed Feb 29, 2012 1:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: call oracle stored procedure in datastage server job
- Replies: 8
- Views: 7553
- Tue Feb 28, 2012 11:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: call oracle stored procedure in datastage server job
- Replies: 8
- Views: 7553
call oracle stored procedure in datastage server job
I have one long oracle procedure which I want to execute via datastage server job. It is not taking any parameters and not returning anything. It is extracting data from some mainframe tables (via db links) and loading data in oracle target tables. It is a long procedure that has got cursors, execut...