Receive port issue

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Receive port issue

Viewing 1 reply thread
  • Author
    Posts
    • January 29, 2008 at 12:47 PM #18848
      community-content

        Hi,
        How to call procedure in receive port (using oracle adapter)?
        I have a receive port which connects with oracle. And I have a procedure/packge which retruns records from table. I want to make this receive port to call that procedure and get the result from it,how can i call it?
        Do i need to do anything on Receive port Transport Properties?
        There are Poll SQL statment, Post Poll SQL Stament, Managing events.. do i need to do anything here to make the receive port call the procedure?

        Thank you in advance,

        —
        Thank you,

        Siva

      • April 14, 2008 at 3:54 AM #19324
        community-content

           Hi Siva,

           could you post a sample of your stored procedure code? because it makes a big difference whether you use OUT CURSOR, or just a Select statement before the end of the procedure.

          you can try writing statements like “Select Owner.PackageName.ProcedureName from dual”. this should work unless you don’t perform any DML operations inside the procedure or the function.

           

          hope this helps,

          Mike 

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