External SQL functions exported by DLLs

[Peter Sullvan]

We have a few rather advanced calculation routines
developed in C++. Currently we are using a Sybase ASA
database for our app. and these routines are accessible
by so called external functions exported by a DLL
(dynamic link library) that we wrote in C++. Sybase
supports this quite nicely.

The client app can call such routines by:

"select get_roof_angle( ) as angle from dummy;"
or
":angle = call get_roof_angle( );"

Now we are checking if other databases can provide us
with similar abilities. So I just wonder if Oracle
supports the ability to call a routine exported by a
DLL? If yes, does anyone know the SQL syntax to declare
it in Oracle.

Best regards
Peter Sullvan

[GreyBeard]

Re: External SQL functions exported by DLLs

a) this is not an official newsgroup and not carried on all news servers.
you are missing a large part of the possible respondents. If you want
more than b) I suggest you repost to comp.databases. oracle.server

b) the answer you seek lies in Oracle's External Procedure (aka extproc)
capability, which is in their documentation.

/FGB

[Peter Sullvan]

Re: External SQL functions exported by DLLs

Thanks! I'll try there.

P.S.