2 Replies Latest reply: Aug 2, 2007 5:25 AM by 590932 RSS

    ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

    590932
      I am getting an error:

      "ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XYZ' ORA-06550: line 1, column 7: PL/SQL: Statement ignored".

      Stored Procedure:

      PROCEDURE XYZ
      (ip_number IN NUMBER,
      op_error_code OUT NUMBER,
      op_error_text OUT VARCHAR2,
      ret_cursor OUT OUT_CURSOR);

      In the procedure I am selecting a details from few tables with respect to the input parameter 'ip_number'.

      VB Code:

      strConnectionString = CONNECTION_STRING
      Set objConnection = Server.CreateObject("ADODB.Connection")
      objConnection.Open strConnectionString
      Set objCommand = Server.CreateObject("ADODB.Command")

      With objCommand
      .ActiveConnection = objConnection
      .CommandType = adCmdStoredProc
      End With

      With objCommand

      .CommandText = "Pkg_1.XYZ"

      .Parameters.Append objCommand.CreateParameter_
      ("ip_ipnumber",adNumeric,adParamInput,8,strIPNumber)

      .Parameters.Append objCommand.CreateParameter_
      ("op_error_code",adNumeric,adParamOutput,10)

      .Parameters.Append objCommand.CreateParameter_
      ("op_error_text",adVarChar,adParamOutput,512)

      Set RS = .Execute()

      End With



      Its working fine with ASP(VB)+ Oracle9i + Windows2000.

      But in ASP(VB) + Oracle 8.1.7 + Windows2000, its giving this error:

      "ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XYZ' ORA-06550: line 1, column 7: PL/SQL: Statement ignored".


      Please help.