Call an Oracle Function from Access

[MikeDamone]

I'm looking for a way to call an Oracle function from Access. I was doing an inline query from Access to Oracle using a linked table but I had to use the Top 1 feature of Access to limit my result to 1 record. It is very slow. In oracle I can use rownum = 1 which is much faster.

So I'd like to create a function on the Oracle database that incorporates rownum = 1 and then call the Oracle function from an Access query. Is this possible? Thanks!!

 

[PHV]

Why not use a passthru query with native oracle sql ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886