pl sql code on access DB

[Archana]

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.

 

[John W. Vinson]

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.