As far as my knowledge goes DS does'nt support out parameters.
Regards
Shiv
Datastage and Stored Procedure
Moderators: chulett, rschirm, roy
If you are passing the stored procedure correctly, DataStage is oblivious to what happens within the stored procedure. What is the error you are getting? Is it an Oracle error? Depending on your need you could define the stored procedure parameter as INOUT. However, you'll never get anything out. Oracle stages are one-way. In or out. (Input or Output) They are not both. If you want A (single) value out, then you can get around this by encapsulating your stored procedure into a function call and calling via a reference lookup in a User defined SELECT. You could get multiple values via an array function return but that's got to be way too much work. By the way, doing a stored procedure call in the OCI stage is Unsupported. It works but you'll need to do it in ODBC if you want Ascential Support.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: