Executing Stored Procedure from Access

F

Frank

Hi,

When I try to execute a stored procedure from Access Pass
Through Query I get ODBC- Call Failed, [Oracle][ODBC]
Syntax error or access violation.(#0). I have selected the
right DSN and have access to tables.

In SQL Pass-Through Query I have:
Execute insert_into_Test (this is the prcedure name in
Oracle)

Please Help.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Stored Procedure Date Parameter Conversion 4
SQL Server Stored Procedure timeout 3
how to call Oracle Stored Procedure from MS ACCESS 2007 VB 5
sql stored procedure 1
Access pass-through query to Oracle 10g stored procedure - results 1
Data source name 1

Top