Passthrough query to Oracle SP

[citychap26]

Hi Guys and gals,

It's been a log time since I've been on here !!! Just a quickie, I want to run (execute) a stored procedure in Oracle 10g.

I have put the folowinmg systax in a spreadsheet:

begin
proc_name;
end;

set the following in MS Access query properties:
1 saveed the connection string
2 set returns records to no

Sadly I get an ODBC error:

ORA-06550;line1, column 6 etc etc
etc

I could simply creade a script and run it in SQL Plus.

Thanks in advance.

Cheers

SK