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:
mY Procedure in oracle begin as: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
Error in exception VBCode:create or replace procedure PROCEDURE_ONE ( P_ANO_MES in number ) is
The procedure work fine when executed only, What is wrong in my code ?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
Tia





Reply With Quote