Unanswered: Call and Oracle stored procedure from access-Odbc error 3146
Trying to call an oracle 10i stored procedure from ms access 2003. The error I'm receiving is runtime error 3146 odbc call failed. I am on a standalone machine. Both the access application containing the call and the oracle database that contains the stored procedure are on the same machine.
The stored procedure runs fine in plsql. The procedure selects certain records from a single table, parses the fields and inserts them into another table.