I have BizTalk 2006 and Microsoft BizTalk Adapter for Oracle Database problem when using stored procedures.I have created PL/SQL procedure to Oracle database:
SQL> desc XXDEB_CALL_SERVICES;
PROCEDURE CHECK_FILE_EXIST
Argument Name Type In/Out Default?
—————————— ———————– —— ——–
P_FILENAME VARCHAR2 IN
P_FILEOK BOOLEAN OUT
BizTalk created this kind of schema:
<Schema>
| — CHECK_FILE_EXIST
| — P-FILENAME
| — CHECK_FILE_EXISTResponse
| — P-FILEOK
I used Static Solicit-Response send port to send P_FILENAME and to receive P-FILEOK. However it returns this to event log:
System defined exception
Call to CHECK_FILE_EXIST@OracleDb://TERPSAND/XXDEB/Procedures/XXDEB_CALL_SERVICES
Implementation = OracleDb://TERPSAND/XXDEB/Procedures/XXDEB_CALL_SERVICES
Source: OracleDb
Error Code: 6550 (0x1996)
Cause: OracleDb://exception=DBException (Unique ID <none>)
HY000 : [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CHECK_FILE_EXIST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Exception data:
struct DBException =
WideString StatusCode = "HY000"
WideString Description = "[Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CHECK_FILE_EXIST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
What I’m missing here?