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: Calling perl from Oracle PL/SQL

Re: Calling perl from Oracle PL/SQL

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 01 May 2002 23:25:39 GMT
Message-ID: <3CD07970.46D35ADE@exesolutions.com>


Christopher Boyle wrote:

> Is there a way to call perl modules from within an Oracle PL/SQL procedure?
> I have no problem calling a PL?SQL procedure from perl and I can call a host
> command from SQLPlus or from within oracle Forms but PL/SQL does not have a
> host command. My intent is to call the perl code from a trigger and use the
> response to update a table. I vaguely remember reading somewhere that i
> could wrap the perl code in java but I havn't a clue how to accomplish that.
> I have tried RTFM but i can't seem to identify the right FM. Thanks for any
> help,
>
> Chris

Look at the DBMS_PIPE built-in package.

Daniel Morgan Received on Wed May 01 2002 - 18:25:39 CDT

Original text of this message

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