Unable to see scama for store procedure of oracle

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Unable to see scama for store procedure of oracle

Viewing 2 reply threads
  • Author
    Posts
    • September 19, 2006 at 3:01 AM #15727
      community-content

        Hi all

        i am working on Biztalk 2006.

        I have installes ODBC drivers also.

        i have created one stroe procedure. but when i add this in biztalk , i am unable to see parameters in scama.

        so how can i solve this problem?

        or can i use package for this?

        Thanks.

        Purushottam.

      • September 19, 2006 at 6:34 AM #15732
        community-content

          can i see that sproc.

          R-

          • September 19, 2006 at 11:01 PM #15750
            community-content

               Hi Nar_BTS.

              My store procedure is like this..which i am not able to see in schemas.

              CREATE OR REPLACE
              PROCEDURE RET_REF_CURSOR
              ( p_return_cur OUT SYS_REFCURSOR)

              IS
              BEGIN
                OPEN p_return_cur FOR
                SELECT * FROM emp_mast WHERE <CONDITION HERE>
              END ;

              Regards.

              Puru.

              • September 20, 2006 at 6:36 AM #15752
                community-content

                  PURU,

                  Try this…

                  CREATE OR REPLACE
                  PROCEDURE RET_REF_CURSOR
                  ( p_return_cur OUT SYS_REFCURSOR)

                  IS
                  BEGIN
                    OPEN p_return_cur FOR
                    SELECT * FROM emp_mast WHERE <CONDITION HERE> FOR XML AUTO, XMLDATA
                  END ;

                  Nar- 

                   

            • November 22, 2006 at 11:14 AM #16497
              community-content

                A Package is necessary when using Sprocs on Oracle 9i or 10g.

                I'm not sure if "SYS_REFCURSOR" is available through the BizTalk Oracle adapter, but this is something to verify as well.

                If you're new to Oracle stored procs, BizTalk, OR the Oracle adapter I would suggest writing a simple sproc that takes IN a single number or varchar parameter and sends it back as an OUT parameter.  Don't forget the package.  This simple black-box approach helps you isolate more fundamental system issues.

                 BizTron

                • December 8, 2006 at 12:56 PM #16795
                  community-content

                    Reference cursors are not supported. Neither are User Defined Types.

                     

                     

                     

                     

                     

                     

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