[AccessD] Oracle into Access

Hi Mike,

Not entirely clear on what a "Custome Package" is in Oracle. But I use 
Access front ends to Oracle databases every day, primarily using ODBC Linked 
tables. I have a couple applications that I use pass-through queries. With a 
pass-through query you create an Oracle SQL statment and it is then sent 
directly to Oracle without interpretation by Access. This allows you to do 
anything you could do using another SQL to Oracle interface, including 
calling Oracle Stored Procedures or custom functions. So I think the answer 
to your question is YES.

Have a look in the Access help on "Pass-Through Query" and perhaps it will 
get you started.

Gary Kjos
garykjos at hotmail.com





>From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: [AccessD] Oracle into Access
>Date: Wed, 16 Apr 2003 09:59:33 -0600
>
>
>Hi Everyone,
>
>Has anyone know if it is possible to call a custome package from Oracle
>and run it in Access?  Is this possible?
>
>Thanks,
>
>Mike Gowey, MCP
>Technical Support Analyst
>SRCI ISSD Team Leader
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail