Unanswered: Calling an 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. 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.
"is oracle db on same PC" is database which need to be access is on machine or on other machine/server?
"do you have oracle installed on your PC" If they are different machine, is oracle installed on machine from where procedure is tried to be accessed.
Even I never saw this problem but want to make sure some basic requirment are getting fullfilled.
Any correction is welcome if I am giving any misleading information.