Re: External Procedures on Oracle 8.

From: <rangelot_at_my-dejanews.com>
Date: Tue, 30 Mar 1999 18:34:30 GMT
Message-ID: <7dr5fl$uar$1@nnrp1.dejanews.com>

In article <36F62BA1.8CAB456A_at_email.mot.com>, Keith Jamieson <pdkj02_at_email.mot.com> wrote:
> <HTML>
> 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
>
> The entire session was as follows:
>  
> Start the extproc process
>
> 1) Create a  c object file test.o using cc -Aa test.c
> 2) Create a shared library and store object file: ar -r 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
>  
> After step 6 I receive the following error messages:
> ERROR at line 1:
> ORA-06520: PL/SQL: Error loading external library
>
> When I look this up using oerr I get the following:
> Cause: An error was detected by PL/SQL trying to load the external
> library dynamically.
> Action: Check the stacked error (if any) for more details;
> ORA-06522: Exec format error
> ORA-06512: at schema_name.procedure_name, line 0
> ORA-06512: at line 1
>
> The c object is insignificant in that all it does is execute a printf
> statement.
> I include it here for completeness.
> void test(void);
> #include <stdio.h>
> void test(void)
> {
>      printf("Hello Keith\n");
> }
>
> I suspect the problem is either
> 1) You cannot call an External Procedure from SqlPlusd
> or/and
> 2) That the shared library has not been created properly.</HTML>
>
>

Keith,

You CAN call an external procedure from SQLPLUS. Make sure you have configured NET8 correctly and that you are not having any permission problems at the UNIX file system level.

Regards.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 30 1999 - 12:34:30 CST