Error returned on Unix 'mv' system call.

2007-01-08 Thread Mark.Cummings
I am migrating an Oracle 9i to Oracle 10g database, and Perl 5.0.4 to Perl 5.8.7 in Sun Solaris environment. Using Perl 5.8.7, the following legacy code segment is returning a '-1' return code on the system call to execute the 'mv' command. Note that the mv request is across directories. sub

Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread dave.salisbury
Dear all, Appreciate if someone can help me with this. I have a Solaris 5.6 Generic_105181-33 box on which I have Perl version 5.005_03. I also have Perl modules DBI (version 1.14) and DBD::Oracle (version 1.06 - I think?? - how can I check this?) I am using the following string to connect to a

Re: Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread John Scoles
I would say yes as DBD::Oracel 1.06 is about 13 revisoins out of date. - Original Message - From: [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Monday, January 08, 2007 11:04 AM Subject: Problems using an old version of DBI to connect to a remote Oracle 10g database Dear all,

Re: Recommended load balancing solutions (especially with PostgreSQL)?

2007-01-08 Thread Mark Stosberg
Henri Asseily wrote: I don't know if I uploaded the latest version of DBIx::HA to CPAN, I'll do it asap. The docs for DBIx::HA say It is very simple to load-balance across read-only database servers. Simply randomize or reorder the 'db_stack' entry in your database configuration on a

RE: Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread Reidy, Ron
This may not be a DBD::Oracle issue, although your modules look a little dated. Did you check you instance alert log and find the generated trace file? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January

DBD::mysql 4.001 Released!

2007-01-08 Thread Patrick Galbraith
Dear users and developers, I'm pleased to announce the release of DBD::mysql 4.001! This fix comes on the heels of 4.00, and we've changed versioning a little bit per feedback. This release fixes many bugs that were lingering in rt.cpan.org Per ChangeLog: * Fix handling of unsigned integer

Re: Error returned on Unix 'mv' system call.

2007-01-08 Thread Jonathan Leffler
If rename works and mv doesn't, use rename everywhere. It is quicker, simpler, less insecure, and more consistent too. Actually, I can't think of a reason to keep mv around. On 1/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am migrating an Oracle 9i to Oracle 10g database, and Perl

Re: Error returned on Unix 'mv' system call.

2007-01-08 Thread Shail Dahal
rename didnot work across the file system as it states in Perldoc, in that case mv command is a saver.. --- Jonathan Leffler [EMAIL PROTECTED] wrote: If rename works and mv doesn't, use rename everywhere. It is quicker, simpler, less insecure, and more consistent too. Actually, I

Re: Oraperl $ora_errno problem with $ora_fetch.

2007-01-08 Thread Nathan Morrow
Below are the test runs of the following script: BEGIN SCRIPT test_fetch.pl #!/usr/local/perl5.8.4/bin/perl -w use Oraperl; ora_version; my $lda = ora_login('','','') or die Connect failed: $ora_errno, $ora_errstr ; $lda-debug(4); my $select_stmt = q{select application from busndate where