Re: Calling External Procedures on Oracle 8

From: <xhanin_at_my-dejanews.com>
Date: Mon, 19 Apr 1999 08:12:10 GMT
Message-ID: <7feogl$oes$1@nnrp1.dejanews.com>

Well, I know that this is not really the good group to post this message, but my problem is close to the problem described here. I am working under HP UX 10.20, and I have to use a shared library (in fact, this shared library is to be used with Java Native code). The problem is that this shared library must call routines only available in static libraries (not compiled in Position Independent code). Is it possible to create such a shared library without recompiling the static library (we do not have the sources any more !) ?

In article <36F7931B.AC17E1C_at_email.mot.com>, Keith Jamieson <pdkj02_at_email.mot.com> wrote:
> <HTML>
> Okay, sorry for replying to my own post but I think this may be of some
> use to others out there.
>
> Theere were two problems:
>
> Problem 1: When compiling the object, you need to create position
independent
> object code. This is done by specifying the +z option on HP UX 10.2. It
> has to be compiled this way so that it can be put into a shared library.
> eg cc -Aa +z test.c
>
> Problem 2:  As I suspected was creating the shared library. The
> correct command for HP Ux 10.2 is :
>
> ld -b -o library_name object_file.
>
> Keith Jamieson wrote:
> <BLOCKQUOTE TYPE=CITE> I am trying to create an external procedure
> using Oracle 8 on hp-unix 10.2
> I have successfully created and registered an external library.
> I have also successfully defined a procedure to call the External library.
>
> I am trying to execute the procedure using Sqlplus
>  
>  
>
> I did start the extproc process, but this didn't make any difference.
>
> The corrected session is as follows:
>
> 1) Create a  c object file test.o using cc -Aa +z  test.c
> 2) store it in a library ld -b -o test_lib.so test.o
> 3) enter Sqlplus
> 4) create library LIB as '/home/keithj/test_lib.so';
> 5) create or replace procedure test as EXTERNAL
> LIBRARY LIB
> NAME "test"
> LANGUAGE C;
>
> 6) exec test
>  
>  
>  
>
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  </BLOCKQUOTE>
>  </HTML>
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 19 1999 - 03:12:10 CDT