Re: 'AllTables' method in DBIx:.Database returns nothing with CSV files

2010-04-19 Thread Robert Roggenbuck
Did you tried it with an absolute path to f_dir? Greetings Robert -- ozarfreo schrieb: I am using DBIx::Recordset to access a directory with CSV files, and the method DBIx::Database-AllTables seems to return just an empty hash reference. I'm talking about the following code: use

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: DBD-Oracle 1.24a reports ORA-24334 in t/58object.t

2010-04-19 Thread Charles Jardine
On 16/04/10 17:29, Everett, Timothy S wrote: This issue was previously reported by other people in thread DBD-Oracle 1.23 reports ORA-24334 in t/58object.t but I could not find any answers. I'm trying to install DBD-Oracle 1.24a with this environment: - perl 5.8.7 built for

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

Problems with external password store.

2010-04-19 Thread Howard, Chris
I have two database servers, there are some differences between the way that perl dbd/dbi is installed on these machines, but both are running HP-UX and Oracle 10g. I am trying to use external password store (oracle wallet) to change scripts with embedded login information to be more secure. On

RE: Problems with external password store.

2010-04-19 Thread Howard, Chris
TNS_ADMIN is not set in either case. that's an alternative to the local $HOME/.sqlnet.ora file? -Original Message- From: Michael Broadwater [mailto:mbroad...@yahoo.com] Sent: Monday, April 19, 2010 10:57 AM To: Howard, Chris; dbi-users@perl.org Subject: Re: Problems with external

RE: Problems with external password store.

2010-04-19 Thread Howard, Chris
Yes. -Original Message- From: Michael Broadwater [mailto:mbroad...@yahoo.com] Sent: Monday, April 19, 2010 11:43 AM To: Howard, Chris; dbi-users@perl.org Subject: Re: Problems with external password store. Does the perl script work without using the wallet? -Mike