Results 1 to 5 of 5

Thread: [RESOLVED] Error when to call Stored procedure

Threaded View

  1. #1

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Resolved [RESOLVED] Error when to call Stored procedure

    Hi

    I trying to call a procedure passing only parameter, but return me error when stat.
    The parameter is value of DTpickcer in format AAAAMM . plese see:

    Code:
         Set cmd = New ADODB.Command
          nAno_mes = Format(dtpAnoMes.Value, "yyyymm")
          
          Screen.MousePointer = vbHourglass
          With cmd
                 .ActiveConnection = cn
                 .CommandText = "PROCEDURE_ONE"
                 .CommandType = adCmdStoredProc
                .Parameters.Append .CreateParameter("@P_ANO_MES", adNumeric, adParamInput, nAno_mes)
                .Execute
          End With
    mY Procedure in oracle begin as:

    Code:
    create or replace procedure PROCEDURE_ONE ( P_ANO_MES in number ) is
    Error in exception VB
    Code:
     ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to 'PROCEDURE_ONE'
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    The procedure work fine when executed only, What is wrong in my code ?

    Tia
    Last edited by mutley; Feb 7th, 2011 at 01:26 PM.

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