Någon som har lite kod som beskriver hur man anropar 'stored procedures' i Oracle från Access97

Exempel:

<code>
Private spCmd As ADODB.Command
Private spPersonId As ADODB.Parameter
Private spLastName As ADODB.Parameter

Set spCMD = conn

With spCMD
.ActiveConnection = conn
.CommandType = adCmdStoredProc
.CommandText = "get_last_name"
.Set spPersonId = & _
Createparameter(pPersonId", adDouble, adParamInput)
.ParametersAppend spPersonId
Set spLastName = & _
Createparameter(pPersonId", adVarChar, adParamInput, 25)
.ParametersAppend spLastName
End With

spPersonId.Value = 12345
spCMD.Execute

MsgBox "Efternamnet är: " & spLastName.Value
</code>


/Pelle