Using Custom Functions from Oracle DB

[Paul Hammond]

I have an ODBC link to some table in and Oracle database. Can I use
functions in my query that are defined in that database? I have done this
with SQL Server Reporting Services, but in Access I get an "Undefined
Function" error. If I can't use the function I will be forced to link to
several more tables to get the bit of info I need with resulting performance
problems.

TIA

Paul Hammond
Richmond, VA

 

[Jeff Boyce]

Paul

Perhaps another option is to create either a stored procedure-equivalent or
a view-equivalent in the Oracle database, using the Oracle function there,
then calling the sp/view from Access.

Note that this is also an option in an Access/SQL-Server configuration.

 

[Paul Hammond]

I have read only access to the Oracle db and can't created any views, sp
there. Wish I could.

Paul
--