Re: Probelm with EXTERNAL procedures
Date: 2000/01/31
Message-ID: <873dfj$1ff$1_at_nnrp1.deja.com>#1/1
Thanks Fehrenbacher
It worked for me as well.
Its surprising though that I could not find a mention of this method in
any Oracle documentation source.
For those of you who might be using external procedures in the future,
do remeber to use extern "C" with your function/procedure declarations
if you are using C++ compiler.
Cheers
Owais
In article <3891A4FD.D277E73_at_i-core.de>,
Judith Fehrenbacher <fehrenbacher_at_i-core.de> wrote:
> OK: I had exactly the same problem. My resolution was to put the
extern "C"
> in front of my function declaration, because I'm using a C++ Compiler.
Maybe
> this helps you too...
>
> Owais Anjum wrote:
>
> > I've done both the things. I've also started extproc listener in
> > listener.ora and tnsnames.ora files. That is why I am getting the
error
> > message from extproc.exe which is titled "Bad Image".
> >
> > I'll try to get the document by tech support. I'll be waiting for
more
> > feedback by you people though!
> >
> > Cheers
> >
> > In article <86otap$osf$1_at_nnrp1.deja.com>,
> > Nabil Courdy <moab_at_emirates.net.ae> wrote:
> > > Have you compiled the procedure that references
> > > the external procedure?
> > >
> > > ALTER procname COMPILE
> > >
> > > Also, you must start a extproc listener which
> > > must be defined in the listener.ora and the
> > > tnsnames.ora.
> > >
> > > There is a nice short document that tech support
> > > can send you on how to call external procedures.
> > >
> > > >
> > > > I am using external procedure to call a C dll from a stored
procedure.
> > > > Breifly stating, I have performed the following steps:
> > > >
> > > > 1. Made a C dll. (e.g. notifier.dll)
> > > > 2. Declared the data dictionary library in Oracle. (notify)
> > > > 2. Defined the wrapper external procedure in Oracle with similar
name
a
> > > > parameter parameters as of the C procedure
> > > >
> > > > Now when I make the call to this external procedure, I get this
Error
at
> > > > the client side:
> > > >
> > > > ORA-06521: PL/SQL: Error mapping function
> > > > ORA-06522: Unable to load symbol from DLL
> > > > ORA-06512: at "IPORA.IPNOTIFY", line 0
> > > > ORA-06512: at line 1
> > > >
> > > > P.S. this error is generated by extproc.exe with the title "Bad
Image"
> > > > I am using WinNT client with Oracle Server 8.0.4 on winNT as
well.
> > > >
> > > > I am unable to figure out where things are going wrong. Can any
give
a
> > > > clue to what might be the problem area.
> > > >
> > > > Thanks and regards
> > > > Owais
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > --
> > > Nabil Courdy
> > > mooab_at_emirates.net.ae (Sub moab for mooab)
> > > ======================
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > --
> > Owais Anjum
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jan 31 2000 - 00:00:00 CET