Calling Oracle Stored Procedures - Help! (1 Viewer)

[rmancuso]

Does anyone have experience with Oracle? I usually call MS SQL stored procs from Access and I now have a client that uses Oracle.

I don't know how to write stored procedures in Oracle so that they can be called in Access.

Can anyone help?

 

[FoFa]

I have not written an Oracle package, but have executed them.
To exec one it is:
BEGIN Oracle_Package_Name(Parameters); END;

 

[SQL_Hell]

Heres an example of executing a Oracle package in VBA

http://answers.google.com/answers/threadview?id=42511