CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001
    Posts
    4

    Stored Procedure

    Sorry for my english.

    I have such problem
    Exist stored procedure, It has two input parametrs
    god and nsrt
    god - has type varchar2, and nsrt - number
    (database Oracle8).
    Below cod:

    Set cm1 = Server.CreateObject("ADODB.Command")
    Set cm1.ActiveConnection = cn
    Set param1 =
    cm1.CreateParameter("god_",adChar,adParamInput,20,god)
    cm1.Parameters.Append param1
    Set param2 = cm1.CreateParamete "nsrt_",adNumeric,adParamInput,22,nsrt)
    cm1.Parameters.Append param2
    cm1.CommandType = adCmdStoredProc
    cm1.CommandText = "AresSelectFromEsert1"

    Appear message:
    ORA-06550: Row 1, column 7: PLS-00306: error type arguments in 'ARESSELECTFROMESERT1' ORA-06550: Row 1, column 7: PL/SQL: Statement ignored .
    Please help.



  2. #2
    Join Date
    Aug 2000
    Location
    Namibia
    Posts
    139

    Re: Stored Procedure

    To Debug I suggest you try and iterate through the command.parameters collection to check if their all there. Also test some of the properties, direction, value, type.
    Show us the execute statement as well.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured