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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Probelm with EXTERNAL procedures

Re: Probelm with EXTERNAL procedures

From: Judith Fehrenbacher <fehrenbacher_at_i-core.de>
Date: Fri, 28 Jan 2000 14:55:39 +0100
Message-ID: <38919FDA.6D1C42E1@i-core.de>


I've exactly the same problem with exactly the same ORA errors and I'm working under HP Unix 11.0.
But: I succeeded in calling another 3GL-Function before, and I absolutely cannot see any difference in doing my work.. 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
> Senior Software Engineer
> Kaps Computing, Pakistan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jan 28 2000 - 07:55:39 CST

Original text of this message

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