pl sql code on access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Archana - 01 May 2008 06:46 GMT

Can we write and execute Pl/SQL procedures, functions and packages on access
database tables. I want to write a procedure which uses cursor and some
advance features of PL/SQL on access database.

Reply to this Message

John W. Vinson - 01 May 2008 18:28 GMT

>Can we write and execute Pl/SQL procedures, functions and packages on access
>database tables. I want to write a procedure which uses cursor and some
>advance features of PL/SQL on access database.

No.

PL/SQL is a part of the Oracle database system. It is proprietary to Oracle
and is not available in Oracle's competitor, Microsoft's, programming
environment.

On the other hand, Access includes VBA (Visual Basic for Applications) as an
integral part of the program, and you can do anything in VBA which can be done
in PL/SQL. You'll need to do it differently, since it's a different language
with a different conceptual framework, but the two languages are equally
capable.

Signature

John W. Vinson [MVP]

Reply to this Message