In my application I have a call to an Oracle procedure that bombs out on .execute with an ODBC call fail error. If I go in to Oracle and exec the procedure that is being called the procedure runs fine, it's just when I call it from the application.
The code to call this procedure is the same as the code to call other procedures within the application and all the other procedures are called and executed correctly from the app. I can't see any difference in the failing one from any other.
Here is the code that is being run from the app if it's any help to you.
Sub DeleteSystemTemp()
strsql = "{call delete_system_temp}"
Set qryDelChanges = con.CreateQueryDef("", strsql)
qryDelChanges.Execute
End Sub
Suz
The code to call this procedure is the same as the code to call other procedures within the application and all the other procedures are called and executed correctly from the app. I can't see any difference in the failing one from any other.
Here is the code that is being run from the app if it's any help to you.
Sub DeleteSystemTemp()
strsql = "{call delete_system_temp}"
Set qryDelChanges = con.CreateQueryDef("", strsql)
qryDelChanges.Execute
End Sub
Suz