Error acessing DB thru JDBC from XI

[former_member181967]

Hi,

In my scenario, I'm trying to access external DB using JDBC, using a predefined data type and the interface defined will call a store procedure. The error looks like this:

<b>Unable to execute statement for table or stored procedure. 'sap_xi' (Structure 'Statement') due to java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SAP_XI' ORA-06550: line 1, column 7: PL/SQL: Statement ignored</b>

Can anyone giva me a hand ?!?!?

Regards,

JMMatos

[moorthy · Accepted solution]

Hi Jose,

is there any arguments are missing in the input message to the JDBC..? Are u using stored procedure here ?

Check this SAP note -636475,498631

Question 17 on JDBC Adapter FAQ-831162

May be useful

If stored procedure, you can check this blog to get the exact structure in the output-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

Moorthy

Message was edited by: Krishna Moorthy P

[former_member181959]

Hi,

How did u solve this problem?

I am facing similar problem here with the same error message. Please help me out.

Regards,

Prasad Babu.