Calling SP with Parameters in OCI8

[admin]

I don't believe that you need the ';' at the end. I have done a similar
thing to your second way, the only difference being I was doing the call in
the 'User-defined' tab and it definitely works.

-----Original Message-----
From: Venkat [mailto:nvkuriseti@rediffmail.com]
Sent: 27 January 2004 09:22
To: datastage-users@oliver.com
Subject: Calling SP with Parameters in OCI8


Hey All,

Right now Im using DataStage 5.2 (Server: Unix).

Im calling an Oracle Stored Procedure with 11 parameters in Target OCI8
"After tab". But Im passing Target Columns as Stored Procedure parameters
here. For example,

CALL
SCOTT.SP_INS_EMPLOYEES(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,H
IRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID);

The above parameters,

EMPLOYEE_ID,FIRST_NAME,LAST_NAME.... are in Target OCI8 Columns tab.

While running this job, Im getting the following error:

Message:
jSPINSEMPNew..ORAOCI83: ORA-06576: not a valid function or procedure name

And I tried in another way like,
CALL SCOTT.SP_INS_EMPLOYEES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11);

But this is also not correct, and again im getting another error...

Message:
jSPINSEMPNew..ORAOCI83: ORA-01008: not all variables bound.


So, how to i proceed the above problem? Pls help me out in this.

Regards,
Venkat


Department for Environment, Food and Rural Affairs (Defra)

This email and any attachments is intended for the named recipient only. Its unauthorised
use, disclosure, storage or copying is not permitted. If you have received it in error, please
destroy all copies and inform the sender. Whilst this email and associated attachments will
have been checked for known viruses whilst within Defra systems we can accept no
responsibility once it has left our systems. Communications on Defra's computer systems
may be monitored and/or recorded to secure the effective operation of the system and for
other lawful purposes.

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users