Invoking PL-SQL from Datastage using OCI stage
Posted: Mon Jul 23, 2001 10:04 am
Hello everyone ,
How do I invoke a Oracle PL-SQL procedure using an Oci stage ?
The manual says
--------------------
For each stmt terminate it with a semi colon
Do not use a trailing semi colon
What we did :
-------------------
The statement was given in user defined SQL
update sku_Table set dsc=123 where code=123 ;
The error we recd
------------------
OCI error invalid character
Our question
-------------
How do I invoke a Oracle PL-SQL procedure using an Oci stage ?
thanks for your time
derick
____________________________________________________
http://www.monsterindia.com - The Best Jobs. For the Best Minds.
How do I invoke a Oracle PL-SQL procedure using an Oci stage ?
The manual says
--------------------
For each stmt terminate it with a semi colon
Do not use a trailing semi colon
What we did :
-------------------
The statement was given in user defined SQL
update sku_Table set dsc=123 where code=123 ;
The error we recd
------------------
OCI error invalid character
Our question
-------------
How do I invoke a Oracle PL-SQL procedure using an Oci stage ?
thanks for your time
derick
____________________________________________________
http://www.monsterindia.com - The Best Jobs. For the Best Minds.