dbTalk Databases Forums  

External SQL functions exported by DLLs

comp.databases.oracle comp.databases.oracle


Discuss External SQL functions exported by DLLs in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter Sullvan
 
Posts: n/a

Default External SQL functions exported by DLLs - 03-11-2005 , 07:17 AM






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



Reply With Quote
  #2  
Old   
GreyBeard
 
Posts: n/a

Default Re: External SQL functions exported by DLLs - 03-11-2005 , 07:36 AM






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

Reply With Quote
  #3  
Old   
Peter Sullvan
 
Posts: n/a

Default Re: External SQL functions exported by DLLs - 03-11-2005 , 07:49 AM



Thanks! I'll try there.

P.S.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.