Running Oracle 7 stored procedures from Access

[Jonathan]

I am using Access 97 as a front end for an Oracle 7.3.4 database. I have been unable to work out how to execute stored procedures in the oracle database from the front end. I am using an ODBC direct connection object to access the database, and I just keep getting an "ODBC call failed" error message.<br>
<br>
Help!<br>
<br>
Jonathan

 

[bitbrain]

Have you tried using a pass-thru query?

 

[codehead]

Hi Jonathan,<br>
<br>
Access 97 will give the "ODBC call failed" error message for many different reasons, without telling you explicitly why.<br>
You have to have the appropriate security level to access different objects in Oracle. I would check and see if you have the access to run stored procedures. Oracle may be giving a security error message, but Access 97 isn't passing it on to you.<br>
<br>
Bob

 

[codehead]

Hi Jonathan,<br>
<br>
Access 97 will give the "ODBC call failed" error message for many different reasons, without telling you explicitly why.<br>
You have to have the appropriate security level to access different objects in Oracle. I would check and see if you have the access to run stored procedures. Oracle may be giving a security error message, but Access 97 isn't passing it on to you.<br>
<br>
Bob

 

[Jonathan]

I have tried using a pass through query, but with the same results. I have also tried executing the stored procedure via the SQL TEST program installed with the Oracle 7 client software, and got the same message. The documentation says that this message is caused by either incorrect syntax in the SQL statement, or by not having the "Procedural Option" installed. I have installed everything off the CD - is this on a separate CD?<br>
<br>
Just for completeness, the procedure is called testproc1, and I am trying to run it with the command conMyConnection.Execute "execute testproc1".<br>
<br>
Any more ideas?<br>
<br>
Thanks<br>
<br>
Jonathan

 

[apparition]

I am going to revive this old thread because I am having the same problem. I am trying to run an Oracle procedure from Access 2000 and keep getting the 'ODBC Call Failed' message.