pl/sql though access?
if i have not installed oracle in my computer , can i run pl/sql procedures though ms access (ms office2003 )
- kenzo2047Lv 69 years agoFavorite Answer
If you mean: "does Ms Access run PL/SQL procedures", the answer is definitely no. PL/SQL is Oracle's implementation of stored procedures. It is only available in Oracle databases.
If you ask: "can I use Ms Access to connect to an Oracle databaqse and through that connection call PL/SQL procedures or functions stored in that database, that is possible via ODBC, but you may need to use "pass-through" queries so you can pass Oracle SQL.