Cant call stored proc from MSAccess

I have been working on an MS Access to Oracle DSS for the last year. Recently I tried to execute stored procedures - also built via MS Access queries - but have been unable. I think that I haven't been using the correct syntax since I can't get by the error:

[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00900:invalid SQL statement. (#900)

We are using SQL/NET via ODBC using drivers loaded from Oracle BBS earlier this year. Using 7.1. & Access 2.0. Able to create procedures with Access queries but can't execute them. But, if I log into SQLPLUS as same user I am able to execute the procs.

Please correct my syntax:

Created stored procedure in lower case - test_proc

In Access have tried executing it with both

execute test_proc and test_proc

Both give me the same error. Any ideas?
Thanks in advance. Bill Driebusch Received on Wed Jul 05 1995 - 00:00:00 CEST