Re: Calling a libary on unix from oracle 7.3.4

Check out the Oracle DBMS_PIPE package. Upto 7.3.4 the way to communicate from PL/SQL procs with a Unix process is through pipes. Probably in Oracle 8, you can dynamically load a library from stored procedures.

In article <7sspv8$2ao$1_at_news1.xs4all.nl>,   "Leo van Veen" <leovveen_at_planet.nl> wrote:
> I know that I can include bij using -l in compiling. But for example
I hanve
> made a libary with as function to make the incomming character
capitilized
> and returns the capitilized character:
>
> file test.c
> #include <stdio.h>
>
> char caps(input)
> char input;
> { return toupper(input); }
> --
> cc -c test.c
> ar -v -q libtest.a test.o
>
> So now the libary libtest.a can be called if I link it with another
program.
> My question is: can I call this libary from an oracle stored
procedure.
> (ofcourse this function excists in oracle, but my function is to
specific to
> explain !)
>
> Thanks Leo
>
> Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
> news:37F0BABF.825428D7_at_Unforgettable.com...
> > All you are talking about there is storing object modules in a
library
> > which can then be used during the link step of a build. That really
isn't
> > an Oracle concern. All you need to do is just include the location
of the
> > library in your -L list.
> >
> > Leo van Veen wrote:
> > >
> > > That's right, for example
> > > cc -c test.c
> > > ar -v -q libtest.a test.o
> > >
> > > Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
> > > news:37EFAFCD.A6E640DF_at_Unforgettable.com...
> > > > Can you define what you mean by library? Do you mean a file
that is
> > > created
> > > > and maintained with 'ar'?
> > > >
> > > > Leo van Veen wrote:
> > > > >
> > > > > I'm looking for a solution to call a unix libary from Oracle
7.3. I
> want
> > > to
> > > > > send data to the libary and read date from the libary.
> > > > >
> > > > > Is this possible.
> > > > >
> > > > > If it isn't, Is it possible to use named pipes to send and
retrieve
> data
> > > > > from Oracle to an external application ?
> > > > >
> > > > > Thanks Leo van Veen
> > > > > leovveen_at_planet.nl
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 09:28:53 CDT