5 Replies Latest reply on Sep 28, 2011 7:43 PM by Syed Ullah

    if there is any restriction for procedure input parameter

    846181
      Hello expert,

      I create a oracle precedure, with a input parameter, but when I used this procedure in SAP BO, it showed following error message:

      " a database error occured. the database error text is : cannot parse the stored procedure query: unable to parse stored procedure specification . (WIS 10901)"

      I found if I input a value for this parameter including '&', above error displayed.

      so , will you please tell me if there is any restriction for procedure input parameter?

      Many Thanks,
        • 1. Re: if there is any restriction for procedure input parameter
          sb92075
          843178 wrote:
          Hello expert,

          I create a oracle precedure, with a input parameter, but when I used this procedure in SAP BO, it showed following error message:

          " a database error occured. the database error text is : cannot parse the stored procedure query: unable to parse stored procedure specification . (WIS 10901)"

          I found if I input a value for this parameter including '&', above error displayed.

          so , will you please tell me if there is any restriction for procedure input parameter?
          no restriction regarding PL/SQL procedure
          • 2. Re: if there is any restriction for procedure input parameter
            sb92075
            843178 wrote:
            Hello expert,

            I create a oracle precedure, with a input parameter, but when I used this procedure in SAP BO, it showed following error message:

            " a database error occured. the database error text is : cannot parse the stored procedure query: unable to parse stored procedure specification . (WIS 10901)"

            I found if I input a value for this parameter including '&', above error displayed.

            so , will you please tell me if there is any restriction for procedure input parameter?
            no restriction regarding PL/SQL procedure
            • 3. Re: if there is any restriction for procedure input parameter
              sb92075
              843178 wrote:
              Hello expert,

              I create a oracle precedure, with a input parameter, but when I used this procedure in SAP BO, it showed following error message:

              " a database error occured. the database error text is : cannot parse the stored procedure query: unable to parse stored procedure specification . (WIS 10901)"

              I found if I input a value for this parameter including '&', above error displayed.

              so , will you please tell me if there is any restriction for procedure input parameter?
              no restriction regarding PL/SQL procedure
              • 4. Re: if there is any restriction for procedure input parameter
                Billy~Verreynne
                843178 wrote:

                I create a oracle precedure, with a input parameter, but when I used this procedure in SAP BO, it showed following error message:

                " a database error occured. the database error text is : cannot parse the stored procedure query: unable to parse stored procedure specification . (WIS 10901)"
                This is not an Oracle error message. Such a message will have an ORA error code (or PLS code). Neither can stored procedures be executed as queries. They need to be executed via anonymous PL/SQL code blocks.

                So from the sounds of it, the problem in your case is that the PL/SQL procedure call is incorrectly made.

                Calling a PL/SQL procedure needs 2 basic things:
                - make the call code using an anonymous PL/SQL code block
                - use bind variables for passing input and output parameters
                • 5. Re: if there is any restriction for procedure input parameter
                  Syed Ullah
                  Can you list the portion of the SAP code that makes the call?