I'm trying to run some storedprocedures on an ORACLE DB, but have run into
some problemes.
The statement:
qd(0).Direction = rdParamOutput
will not execute.
Why wont this work.
cn.Connect = "uid=system;pwd=manager;" _
& "DSN=Project98_MSOracle;"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection rdDriverNoPrompt
Set qd.ActiveConnection = cn
qd.SQL = "{call sidata.sidata_nyttforslag(?)}"
qd(0).Direction = rdParamOutput
Set rs = qd.OpenResultset(rdOpenForwardOnly, _
rdConcurReadOnly)