Hi All,
I am using DataStage 6.0 version. I have to call a stored Procedure through DataStage which has a In as well as Out Parameter. The out parameter is of Ref Cursor type. I am using ODBC stage to call this Procedure since we do not have SP Stage in 6.0 version. But I am not able to handle the Out Parameter in the Job , It is giving me parameter/type mismatch error and the job is aborted.
Can anyone tell me if out parameter can be handled in 6.0 version. If yes , how can we handle it?
If No, Is there any alternative to this Problem?
Thanks in advance.
Handling Out Parameter of a stored Procedure in 6.0 version
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Yes, I have checked and the parameter type is same as in the Procedure But for One of the OUT parameters the type in Procedure is of Reference Cursor, which we cannot declare in DataStage so I have declared it as a varchar.
I think all the Problem is because of this reference Cursor type which is not being handled in DS, atleast in 6.0 version.
Any alternative possible to handle this reference Cursor type OUT parameter??
I think all the Problem is because of this reference Cursor type which is not being handled in DS, atleast in 6.0 version.
Any alternative possible to handle this reference Cursor type OUT parameter??
Re: Handling Out Parameter of a stored Procedure in 6.0 vers
Dump the SP and build the logic directly into your job. Is there something magical it is doing that can't be done in your job?Amit_111 wrote:If No, Is there any alternative to this Problem?
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers