Skip to Content
0
Former Member
Jan 18, 2011 at 03:02 PM

Help required in JDBC Stored Procedure

72 Views

Hi All,

i have a requirement where i need to update the Database table using Stored Procedure from PI.

I have the receiver JDBC channel and have done the mapping.

The stored procedure has inputs of type NUMBER, VARCHAR2,DATE. in the message mapping i tried passing the same values in the type field, it throwed an error like UnSuppoted Format. Then i changed the type to integer for NUMBER and String for Varchar2 then also it is throwing an error like

+java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PUT_XXXXX' ORA-06550: line 1, column 7: PL/SQL: Statement ignored +

Can any please help with what type i need to send from PI to Stored procedure?

Also, there two out type fileds defined in the Stored procedure..which i didnt create in my PI structure. Do we need to create that fileds in our structure?

Please help me.

Thanks,

Hemanth.