Re: Need help calling an external function

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 29 Jun 1998 17:08:07 GMT
Message-ID: <3597c9ce.4760505@192.86.155.100>

A copy of this was sent to Markjo_at_my-dejanews.com (if that email address didn't require changing) On Mon, 29 Jun 1998 14:40:33 GMT, you wrote:

>I need to call a function in a DLL from within a stored Proc. I can call the
>fuction from a Sybase stored proc but am having problems calling it from an
>Oracle stored proc. The following is my procedure:
>
>PACKAGE BODY MY_UTILS IS
> PROCEDURE CALL_MY_EXTERNAL_FUNCTION IS
> external library Master.MY_LIB name MyFunction ;
>
>END;
>

Is the function name case sensitive in the .dll (is it C). If so, then use "MyFunction", for example:

CREATE OR REPLACE FUNCTION PLS_MAX(

      x BINARY_INTEGER,
      y BINARY_INTEGER)

RETURN BINARY_INTEGER AS
   EXTERNAL LIBRARY externProcedures
   NAME "find_max" -- Name of function call. Quotes preserve lower case. .....

>And this is what I get when I call it:
>
>ERROR at line 1:
>ORA-06521: PL/SQL: Error mapping function
>ORA-06522: Unable to load symbol from DLL
>ORA-06512: at "MASTER.MY_UTILS", line 0
>ORA-06512: at line 1
>
>It finds the DLL OK but has a problem caling the function.
>
>Any help is greatly appreciated!
>
>Mark
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 29 1998 - 12:08:07 CDT