Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle PL/SQL calls via MS Access Pass-Through Query
I am using a MS Access 2000 DB as a front end to an Oracle v8i database. I want to invoke PL/SQL stored procedures and believe that this is achievable through pass-through queries but can't find any documentation on this - merely executing the query doesn't work. Any helpful suggestions?- iansoady
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Generating XML from PL/SQL Procdeures
I need to generate XML output from a PL/SQL procedure rather than from a simple query as described in the Oracle documentation. The procedure will return a combination of single values and tables. Does anyone have experience in this area? I'm using version 8i of Oracle.- iansoady
- Thread
- Replies: 0
- Forum: Oracle: All versions
