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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Trouble accessing sqlplus using perl on NT

Re: Trouble accessing sqlplus using perl on NT

From: Eric Givler <egivler_at_flash.net>
Date: Tue, 12 Sep 2000 17:27:12 GMT
Message-ID: <QHtv5.5329$oc3.286028@news.flash.net>

Why aren't you using DBI to do the commands inside of Perl?

Erik Cohen <cohene_at_sdc-moses.com> wrote in message news:39be5839.14527582_at_news.bellatlantic.net...
> To all:
>
> I am posting this on behalf of a user that I suipport in the capacity
> of webserver admin and dba. Any help you can provide will be
> appreciated.
>
> Erik Cohen.
> SAIC
> erik.l.cohen_at_saic.com
>
>
> We are having a problem invoking sqlplus from Perl when the Perl
> routine
> is called through an URL.
>
> The following are informations regarding the installation:
>
> - We are using ORACLE version 8.1.6 and OAS version 4.0.8.1 on
> NT Version 4.0, Pack 5.0 (40 bit).
> - Both Oracle and OAS were installed on the same NT server,
> but on different subdirectories.
> - In the OAS a listener was set for perl on port 85.
> The directory form, directories were set to map to the location
> where the perl.exe is located and our repl routine is located.
>
> The following are informations regarding the way sqlplus is being
> invoked:
>
> - a cmd file was created that looks like :
> @echo off
> perl -I c:/perl/lib -I c:/xx/yy user_group.pl
> - the user_group.pl file looks like:
> system ("sqlplusw user/password\@database_name",
> "\@c:\\xx\\yy\\bb.sql");
> Note: We also tried using the full path to invoke sqlplus.
> - the bb.sql just inserts a record in the aa table and looks like:
> delete aa;
> commit;
> insert into aa values(2);
> commit;
> exit
> The perl.cmd is then invoked through an URL, but nothing happens.
> If invoked from the DOS prompt (as perl user_group.pl) it works.
>
>
Received on Tue Sep 12 2000 - 12:27:12 CDT

Original text of this message

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