RE: Running Perl from Oracle

Hello Don,

> I was wondering if it would be better to put output to a file and copy the file back to local system.

You could do that, but how do you know when it is finished?

Maybe look into:
http://search.cpan.org/~bnegrao/Net-SSH-Expect-1.04/lib/Net/SSH/Expect.pod#___top

'expect' should excel at this type of problem.

+Dave

--- On Thu, 3/20/08, Dukelow, Don < dukelow%40hp.com">dukelowhp.com>; wrote:

> From: Dukelow, Don < dukelow%40hp.com">dukelowhp.com>;
> Subject: RE: [PBML] Running Perl from Oracle
&gt; To: " perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com&quot; < perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com>;
> Date: Thursday, March 20, 2008, 4:22 PM
> The PATH variable for Oracle is set correctly, but when I
> run the Perl script out of Oracle it doesn't pick up
> all of the everiment variables that a normal Oracle login
&gt; has. The %ENV hash is almost empty, with a very short PATH
>; entry. I ran the program manually and put out all the
> entries to a file. Now when I run the program under Oracle
&gt; I source all the entries back into the %ENV hash. I've
>; checked and they are are there. But it still doesn't
> work, it goes through the motions but doesn't do
> anything.
> The main thing my local Perl script does which is a Linux
&gt; box is go out to a Sun server and excite a script and brings
&gt; back the output.
> $answer = qz(ssh
&gt; lmsSystemName<mailto:lmsSystemName>
>; /usr/local/bin/script);
> I was wondering if it would be better to put output to a
> file and copy the file back to local system.
>
> If anyone has better idea please let me know.
&gt;
>
> -----
&gt; Don Dukelow
> HP License Team
>; Hewlett-Packard Company
> Tel: 810-728-3388
> e-mail: dukelow%40hp.com">dukelowhp.com
>
>
>
> ________________________________
> From: perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com
> [mailto: perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com] On Behalf Of Marty
&gt; Landman
> Sent: Monday, March 17, 2008 3:15 PM
> To: perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com
> Subject: Re: [PBML] Running Perl from Oracle
&gt;
>
> Don,
>;
> I wonder if this is related to the userid that Oracle is
> running out
> of. The easiest approach might be to set PATH to what it
> needs to be
> for this program.
>
> hth,
>; Marty
&gt;
> At 02:04 PM 3/17/2008, Don Dukelow wrote:
&gt; > I have a Perl program that calls the local UNIX ssh
> command, and
> > ssh's into another system and excites a command.
> It takes the
> > output and copies it back and put it in a file.
&gt; >
>; >"my arr = qx(ssh lms$host $lic_quorum_cmd);
> >Print OUT "arr";
> >
>; > It works fine when run as UNIX command line. But when
>; I run it
> > out of Oracle it doesn't seem to be able to find
>; commands. Like
>; > the PATH variable isn't there. Can someone point
&gt; me in the correct
> > direction to fix this?
&gt;
> --
> Marty Landman, Face 2 Interface Inc. 845-679-9387
> Drupal Development Blog: http://drupal.face2interface.com/
> Free Database Search App:
>; http://face2interface.com/Products/FormATable.shtml
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
&gt;
> Unsubscribing info is here:
&gt; http://help.yahoo.com/help/us/groups/groups-32.htmlYahoo!
> Groups Links
&gt;
>
>

Messages in this topic (5) Reply (via web post) | Start a new topic

.