Invoking PL-SQL from Datastage using OCI stage

[admin]

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.

[admin]

Try to remove the trailing semi-column.

Here we were calling a function (returning max(sales_id)+1 for
instance) this way:
insert into mytable (id, field1, field2) values (myfunction(),:1,:2)

The :1 is the first datastage column of the link...

Regards,
Steph.

--- derick j JOSE wrote:
> 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.
>
>
>


=====
|
@..@ |
(----) | - - - - - - - - - - - - - - - - - - - - - - -
( >__< ) | Stephane TISSOT
^^ ~~ ^^ | (stissot@yahoo.com) (stephane_tissot@aldec.fr)

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/