Hi Gurus,
I am trying to execute an Oracle stored procedure from XI which has parameters of type VARCHAR2. How to specify these data types in data type in XI?
I am getting the below message when I execute the stored procedure from XI with data types CHAR/VARCHAR.
com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TEST_PACKAGE.MAIN ' (structure 'statement'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'MAIN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Please let me know.
Thanks
Kalyan