I have imported some jobs from 6.0.1.5 to 7.5.In one of the jobs,I have a ORAOCI stage as lookup and i am using a fully generated qury for that.
But still i am getting the error ORA-01008: not all variables bound.
when i have done a search on this error ,i have seen that there is a patch.
I tried to open the link given for the patch,it is not opening up.
Can any one suggest a solution for this.
ORA-01008: not all variables bound
Moderators: chulett, rschirm, roy
ORA-01008: not all variables bound
Thanks
Sheema
Sheema
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
You'll need a login, but once there you will find the patch under the Recommended Patches in the Software Updates for DataStage:
Note that the fix is for User-Defined SQL with a bonus fix thrown in for the SQL Builder.User-defined SQL in Oracle OCI Stage ALL DataStage 7.5.1 05/26/2005 e73423_ALL_751.zip
Description:
Oracle OCI stage (ORAOCI9) incorrectly binds the lookup column values to the SQL statement which is being executed. This results in the Oracle database error "ORA-1008: Not all variables bound" [ECASE 73423].
Also included in this patch is a fix for the SQL Builder in the Oracle OCI stage, which incorrectly converted a "WHERE" clause to a "HAVING" clause [ECASE 74270].
Compatibility Notes:
This zip archive contains the DataStage Client patch for the SQL Builder, and the server plug in packages for all DataStage 7.5.1 server platforms.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers