On Wed, 4 Jul 2001 [EMAIL PROTECTED] wrote:
> I have a webpage that accepts user input; it is initially processed by a
> Perl program. From that Perl program, I need to pass variables to an
> Oracle PL/SQL procedure. How?
>
> I reviewed several books and online sources and have tried anything that
> looks similar to what I want to do, but nothing has worked so far. From
> O'Reilly's "CGI Programming" book, I found out that there is CGI gateway
> to Oracle, called oraperl, but the PL/SQL procedure is already written
> and debugged so I want to use it, not install/configure oraperl and then
> rewrite/debug the program.
oraperl is an older database interface to Oracle and deprecated in favor
of newer interfaces. The standard way to access Oracle via Perl is either
through DBI or ODBC, depending on your system set up. In fact, I believe
DBI is based upon oraperl and developed into a abstract interface for a
large range of database systems.
See http://dbi.symbolstone.org/index.html for more information on DBI. I
believe the Oracle DBI driver (called a DBD) has ways of directly calling
stored procedures. See
http://dbi.symbolstone.org/cgi/summarydump?module=DBD::Oracle for specific
details on the Oracle driver.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
We are anthill men upon an anthill world.
-- Ray Bradbury
