none
Biztalk Oracle Adapter for Select Procedure RRS feed

  • Question

  • Hi,

    I m working on biztalk 2006 r2 + oracle. i created one select oracle procedure (as below) which is inside package and also define inside package defination but when i try to generate receive schema, i m not able to see the procedure. Is their any diffrent way to write procedure?
    Is anyone can give me the step by step process for same.


    PROCEDURE sp_select_biztalk(OUT_refcursor OUT p_ref_appdetails)
    IS
    BEGIN
      OPEN OUT_refcursor FOR

      SELECT NAME,EMPNO, ADDRESS,PHONE,PROJECT
              FROM TBLBIZTALK WHERE FLAG='Y';


      EXCEPTION
      WHEN OTHERS THEN
      NULL;
    END sp_select_biztalk; 


     i already created procedure (mentioned above) in pakage and in pakage defination.

    I am not able to see select or get procedure in receive port configuration or nor at the time of generating metadata for same.

    I am doing following steps.

    1) Created oracle adapter receive port and location (configured receive location with oracle connection string and able to see oracle database in managing event property. But not able to see get or select procedures)

    2) Created empty biztalk project.

    3) Generated metadata for receive schema using configured receive location. (Right click on project --> Add generated items --> Generate metadata...through this wizard i m using configured receive location).

    i am able to see insert, update procedures but unable to see get or select procedures. How do i do this? 

    Regards
    Girish Fuluskar

    Sunday, March 14, 2010 5:13 AM

All replies

  • I am not able to see select or get procedure in receive port configuration or nor at the time of generating metadata for same.

    I am doing following steps.

    1) Created oracle adapter receive port and location (configured receive location with oracle connection string and able to see oracle database in managing event property. But not able to see get or select procedures)

    2) Created empty biztalk project.

    3) Generated metadata for receive schema using configured receive location. (Right click on project --> Add generated items --> Generate metadata...through this wizard i m using configured receive location).

    i am able to see insert, update procedures but unable to see get or select procedures. How do i do this?  
    Tuesday, March 9, 2010 10:11 AM