none
WCF Oracle DB Adapter Polling Issues? RRS feed

  • Question

  • Hi there,

    I have some questions about wcf oracle adapter. I am using biztalk 2009 and biztalk adapter 2.0.

    Q1: The binding type is oracleDBBinding. I try to receive store procedure but not work. The procedure is

    CREATE OR REPLACE PROCEDURE Procedure1(ID OUT Table.Po_id%TYPE) IS

    as_id Table.Po_id%TYPE;
    BEGIN
      BEGIN
          SELECT Po_id
          INTO as_id
          FROM ( SELECT Po_id FROM Table WHERE Flag = 'N' ORDER BY ID)
          WHERE rownum = 1;     
      END;
      SELECT Po_id
      INTO ID
      FROM Table
      WHERE Po_id = as_id;
      UPDATE Table SET Flag = 'P' WHERE Po_id = as_id;

    END Procedure1;

    Q2: The binding type is oracleDBBinding. I change store procedure to package. I receive store procedure but not work too. The package is

    create or replace package Table_pkg is

       Procedure Procedure1(ID out Table.Po_id%type);
    end Table_pkg;

    create or replace package body Table_pkg is

    PROCEDURE Procedure1(ID OUT Table.Po_id%TYPE) IS

    as_id Table.Po_id%TYPE;
    BEGIN
      BEGIN
          SELECT Po_id
          INTO as_id
          FROM ( SELECT Po_id FROM Table WHERE Flag = 'N' ORDER BY ID)
          WHERE rownum = 1;     
      END;
      SELECT Po_id
      INTO ID
      FROM Table
      WHERE Po_id = as_id;
      UPDATE Table SET Flag = 'P' WHERE Po_id = as_id;
      END Procedure1;

    end Table_pkg;

    Actually, in Q1 and Q2 I can not find oracleDBBinding type sample to receive store procedure or package. My binding setup maybe wrong.

    Q3: I found sample receive package using oracleEBSBinding. I change my project using oracleEBSBinding. My receive location binging Properties is

    polledDataAvailableStatement : SELECT Po_id FROM Table WHERE Flag = 'N'  ORDER BY Po_id

    pollingAction : PollingPackageApis/Apps/Table_pkg/Procedure1

    pollingInput : <Procedure1 xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/PackageApis/Table_pkg"></Procedure1>

    pollingInterval : 600

    pollWhileDataFound : True

    My package receive one record at one time. I log receive data into file. If Table has 10 records Flag is 'N'. After process will output 10 file logs. However

    I got 20 file logs. Every record receive 2 times. Why?

    Please tell me 1.binding type using oracleDBBinding receive store procedure or package setting.

    2. Why oracleEBSBinding type receive package data duplicate?

    Thanks.

     

     

    • Moved by Ben Cline1Moderator Saturday, January 15, 2011 11:27 PM Related to adapters (From:BizTalk Server General)
    Thursday, January 13, 2011 5:24 AM

Answers

  • I am still waiting for an answer to my question.

    Please help me.

    Thanks.

    • Marked as answer by yuan012 Wednesday, March 9, 2011 8:08 AM
    Tuesday, January 18, 2011 6:19 AM