Re: Help on using on *nix and Windows

2010-04-21 Thread Jared Still
On Mon, Apr 19, 2010 at 5:39 AM, newbie01 perl newbie01.p...@gmail.comwrote: Hi Peter, Thanks to your response. Send to the DBI user group as this group is more likely to know about what sqlplus may be. Using sqlplus from within Perl is always an ugly proposition. I've done, others have

Re: Help on using on *nix and Windows

2010-04-20 Thread Shawn H Corey
Shlomi Fish wrote: Hi newbie01, On Monday 19 Apr 2010 12:21:45 newbie01 perl wrote: Hi all, I need to convert a lot of UNIX scripts into Perl. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to connect to Oracle databases. At the moment, installing a DBI is

Re: Help on using on *nix and Windows

2010-04-20 Thread John Scoles
Without DBI you are very limited in what you can do. You might want to take a time machine back and give Oraperl a go http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm Old and unmaintained but at least I think you can run it without dbi cheers John Hi all, I need to convert a lot

Re: Help on using on *nix and Windows

2010-04-20 Thread Bruce Johnson
On Apr 20, 2010, at 3:49 AM, John Scoles wrote: Without DBI you are very limited in what you can do. You might want to take a time machine back and give Oraperl a go http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm Old and unmaintained but at least I think you can run it without

Re: Help on using on *nix and Windows

2010-04-20 Thread John Scoles
Bruce Johnson wrote: On Apr 20, 2010, at 3:49 AM, John Scoles wrote: Without DBI you are very limited in what you can do. You might want to take a time machine back and give Oraperl a go http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm Old and unmaintained but at least I think

Help on using on *nix and Windows

2010-04-19 Thread newbie01 perl
Hi all, I need to convert a lot of UNIX scripts into Perl. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to connect to Oracle databases. At the moment, installing a DBI is not an option. The scripts will be running locally on the servers so technically it

Re: Help on using on *nix and Windows

2010-04-19 Thread Fi Dot
What happens if you try quoting with the SQLEND part? Also, generally, interfacing with anything via external command line tool rather than some API is less reliable and will give you all sorts of problems. Fi. On Mon, Apr 19, 2010 at 2:21 AM, newbie01 perl newbie01.p...@gmail.comwrote:

Re: Help on using on *nix and Windows

2010-04-19 Thread Peter J. Holzer
On 2010-04-19 21:21:45 +1200, newbie01 perl wrote: I need to convert a lot of UNIX scripts into Perl. No, you are trying to convert a Perl script written for Unix into a Perl script which runs on Windows. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to

Re: Help on using on *nix and Windows

2010-04-19 Thread newbie01 perl
Hi Peter, Thanks to your response. Send to the DBI user group as this group is more likely to know about what sqlplus may be. Am trying to convert UNIX scripts to Perl scripts. It just so happen that I have two servers that runs Oracle on Windows, so I've decided to test what I can or I cannot

Re: Help on using on *nix and Windows

2010-04-19 Thread Shlomi Fish
Hi newbie01, On Monday 19 Apr 2010 12:21:45 newbie01 perl wrote: Hi all, I need to convert a lot of UNIX scripts into Perl. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to connect to Oracle databases. At the moment, installing a DBI is not an option.

Re: Help on using on *nix and Windows

2010-04-19 Thread pDale
On Mon, Apr 19, 2010 at 06:17, Shlomi Fish shlo...@iglu.org.il wrote: Hi newbie01, On Monday 19 Apr 2010 12:21:45 newbie01 perl wrote: Hi all, I need to convert a lot of UNIX scripts into Perl. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to connect

RE: Help on using on *nix and Windows

2010-04-19 Thread Carlson, John W.
Would it be possible to install DBI DBD::Oracle in your home folder and test there? John -Original Message- From: pDale [mailto:pda...@gmail.com] Sent: Monday, April 19, 2010 7:33 AM To: newbie01 perl Cc: beginn...@perl.org; dbi-users Subject: Re: Help on using on *nix and Windows