Skip to Content
Former Member
Dec 04, 2006 at 08:41 PM

how to speicfy the Oracle SQL type VARCHAR2 in XI data type


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. 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.