Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> External procedure with Pro*C in it

External procedure with Pro*C in it

From: <djsnyder_at_my-deja.com>
Date: Fri, 15 Dec 2000 21:58:25 GMT
Message-ID: <91e45t$lpc$1@nnrp1.deja.com>

    I have some C functions that I have compiled into a shared library on Unix.
One of the functions contains a SQL statement to insert into a table, so I
compile the file with Pro*C. It compiles fine. I have another C program
that calls the function within my shared library. It runs fine and the shared
library does insert the data into the table.

    I create an Oracle library that points to the shared library, then create a stored
function in the database that executes the routine in the shared library. At
this point, everything seems in place. We have been using external procedures
for a while, and they seem to work OK. This is the first one we have, though that
has Pro*C code in it.

    When I execute the stored function to execute my Pro*C routine, I get the errors
ORA-06520: PL/SQL: Error loading external library ORA-06522: Unresolved external.

    This shared library is the first one that we are using that has Pro*C in it. The
documentation doesn't say anything about being able to use Pro*C routines
as external procedures; but it doesn't say you can't. Am I attempting the impossible?
If not, what am I missing?

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 15:58:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US