I am trying to run a pass-through query as following.
Set qdf = db.CreateQueryDef("")
qdf.Connect = "odbc;dsn=oraacc;uid=msgdrss;pwd=gdrss;server=gdrss"
qdf.sql = "BEGIN keepcompile(TO_DATE('" & Format(StartDateTime, "MM/DD/YYYY") & "','mm/dd/yyyy'),TO_DATE('" & Format(StopDateTime, "MM/DD/YYYY hh:mm:ss") & "','mm/dd/yyyy hh24:mi:ss'), comments_);END;"
qdf.ReturnsRecords = False
qdf.ODBCTimeout = 0
qdf.Execute
qdf.Close
MsgBox comments_
Keepcompile is Oracle procedure, where all the variables are IN type of variables except comments_, it is out type of variable.
If I eliminate comments_ it is working fine
but if I want to get comments out
I am getting error run-time error'3146' ODBC --call failed.
Do you have any idea?
Set qdf = db.CreateQueryDef("")
qdf.Connect = "odbc;dsn=oraacc;uid=msgdrss;pwd=gdrss;server=gdrss"
qdf.sql = "BEGIN keepcompile(TO_DATE('" & Format(StartDateTime, "MM/DD/YYYY") & "','mm/dd/yyyy'),TO_DATE('" & Format(StopDateTime, "MM/DD/YYYY hh:mm:ss") & "','mm/dd/yyyy hh24:mi:ss'), comments_);END;"
qdf.ReturnsRecords = False
qdf.ODBCTimeout = 0
qdf.Execute
qdf.Close
MsgBox comments_
Keepcompile is Oracle procedure, where all the variables are IN type of variables except comments_, it is out type of variable.
If I eliminate comments_ it is working fine
but if I want to get comments out
I am getting error run-time error'3146' ODBC --call failed.
Do you have any idea?