Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> External procedure with Pro*C in it
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