Re: Using DLLs on an Oracle Server 7.3

OK. So, as I understand it, you need something within the Oracle PL/SQL language (in which you would write a stored procedure) to CALL an external, OS- specific, executable. The Oracle7 Server Application Developer's Guide says the following:

"Application developers frequently ask how they can access 3GL routines (such as C or C++ functions) or operating system services from PL/SQL code that is running on a server. One way to do this is to use the Oracle-supplied DBMS_PIPES package. ... It is not possible to call a 3GL routine directly from PL/SQL in release 7.3. This capability will be offered in a future release of the Oracle Server."

In article <369237b8.0_at_news2.ibm.net>,
  "Nicolas Bronke" <NBronke_at_Trinity.de> wrote:
> I am developing some financial applications. To evaluate the data in a
> database I need several financial functions (complex mathematical functions
> e.g. Black Sholes).
> To evaluate the data at the front end may be easy, but it may be faster to
> use stored functions in a sql-statement.
>
> Kind regards
> Nicolas Bronke
>
> Ed.Stevens_at_nmm.nissan-usa.com schrieb in Nachricht
> <76t5jp$2ms$1_at_nnrp1.dejanews.com>...
> >In article <368fbf8e.0_at_news2.ibm.net>,
> >Could you be a bit more specific about what you mean by "use DLL-Functions
> on
> >an Oracle Server 7.3?" What is it you're trying to do?
>
>

--
Ed Stevens
Nissan Motor Mfg. Corp., USA

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 08:41:50 CST