BizTalk Adapter for Oracle Database Procedure Problem

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk Adapter for Oracle Database Procedure Problem

Viewing 1 reply thread
  • Author
    Posts
    • #16120

      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?

    • #16447

      Ok, I was able to resolve this. After I changed return value from boolean to integer everything worked fine. Somehow Oracle adapter couldn't handle the boolen return value.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.