Hi,
I have a problem with calling procedure with parametrs.
After run this code:
....
Set strCommand = New ADODB.Command
strCommand.ActiveConnection = cnn
strCommand.CommandText = "ProcedureName"
strCommand.CommandType = adCmdStoredProc
customer_id = "HAVO"
Set prm = strCommand.CreateParameter("@customer_id", adVarChar,
adParamInput, 20, customer_id)
strCommand.Parameters.Append prm
address_id = "1"
Set prm = strCommand.CreateParameter("address_id", adVarChar,
adParamInput, 2, address_id)
strCommand.Parameters.Append prm
Set recSet1 = strCommand.Execute
'and more 10 parametrs created the same way
....
I have an error:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ProcedureName' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Generaly I must call frocedure on oracle 92 from Access using
Ado.Connection
Any ideas?
mw