Anonymous asked in Computers & InternetSoftware · 9 years ago

pl/sql though access?

if i have not installed oracle in my computer , can i run pl/sql procedures though ms access (ms office2003 )

1 Answer

  • 9 years ago
    Favorite 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.

Still have questions? Get your answers by asking now.