Re: how to get data from a perl script with pl/sql

On Tue, 04 Jul 2006 05:32:33 -0700, schrulle wrote:

> hello there,
>
> I have a problem, since I have never done something like that before.
> I'm having a perl-script (not written by me). this script gets data out
> of a database.
>
> now I need to know how to get this data with pl/sql.
> the developer of this perl-script told me, that I have to do it with a
> tcp connection.
> ok, I found out how to get a tcp connection with utl_tcp.
>
> but what do I have to do then ?????
>
> as you can see, I'm not kind of an expert.
>
> but anyway, I hope that someone can me.
>
> thanks in advance
> mike

There is a Perl API called DBI and you also need DBD::Oracle driver. One can easily call PL/SQL from Perl, no problems whatsoever. Also, one can link Perl to Oracle and invoke it from PL/SQL. It's called "extproc_perl". The last resort would be to communicate with a Perl script directly from PL/SQL. My gut feeling is that the Perl developer in question is simply being uncooperative.

-- 
http://www.mgogala.com