Hi,
How can I get out parameter from storage procedure(on Oracle) in Access?

Plese HELP?
Thanks!

Though I don't have Oracle available to test this, you would need to create a pass-through query in Access with (I think) the following SQL syntax:

{Call PackageName.ProcName (?, {resultset 20, OutParam1, OutParam2, ...})}

or

EXEC PackageName.ProcName (?, {resultset 20, OutParam1, OutParam2, ...})

Then create a DSN using the ODBC driver for Oracle to use as the pass-through queries ODBC Connect Str property. I don't have the Oracle client components installed on my system so I can't create the DSN, but once created, the Connect Str property value would look like:

"ODBC;DSN=yourSystemDSN;Uid=yourUsername;Pwd=yourP assword"

HTH,

Bob

Thanks, but I am still receve this message:

ODBC -- call faild
[ORACLE][ODBC][ORA]Ora-01008:
not all variables bound(#1008)

Can I my problem define on another way:
I use Access as a client, an Oracle as server.
I won to know when I executed procedure on Oracle, that
"she" do her job (some update or delete). And I wont it to know in Access, but I do not how?!


Sorry, my English is bad.
Regards