need help with access pass thru to oracle

I am trying to create a simple form in access 2000 to run an oracle stored procedure with a parameter passed from an entry on a form. I set up the odbc connection ok and have linked the 2 tables in oracle. When I set up a pass thru query to run sql on the tables or run the procedure it fails, giving me either an "odbc call failed" error or a "the microsoft jet engine cannot find the input table or query 'ODBC;DSN=db1;UID=user;PWD=pass;SERVER=db1;'

Not sure what to do here becuase the odbc is connecting ok for seeing the table, but if I try to run 'exec proc_name(50)' I get this error, even when trying a simple sql query on the oracle table it errors out.

ideas anyone?

TIA

try wrapping it in a begin... end

begin
procedure;
end;

thanks

But I tried that - no go, now I'm getting an ODBC call failed error.

I did manage to get a select pass through query working, and even an insert statement, but as soon as I try to run a procedure it craters. I've made sure the user has execute rights to the proc, and I've tried setting the ODBC up as the owner of the tables and proc, same results.

I've also tried switching the ODBC from Oracle to merant to MS - same thing.

Not sure what to try next here...