Install DBI-DBD for Oracle Failure (perl 5.8.5)

2005-01-21 Thread Schutz, Joseph
Hello, I have successfully installed the following on a HPUX B11.0.0 running Oracle 8.1.6.0.0. perl 5.8.5 (using gcc 3.4.1) DBI (1.20) I have errors attempting to install DBD (1.12) for Oracle. I receive fatal error "Inrecognized argument: -Wl,+s". I have read and tried anything

Re: Truncating trailing spaces - looking for alternative solutions

2005-01-21 Thread Chad Terry
Thanks Michael. I will look at ora_ph_type. We use MQSeries in our environment and found that we needed to have at least 5.6.0 to be compatible with the latest version of the MQ module. 5.6.0 was already installed on our system, it came with AIX 5. So, in essence we just cut over to it. We then up

lib/DBI/Const/GetInfo/ODBC.pm is missing info type SQL_DATABASE_NAME

2005-01-21 Thread Phillip Hellewell
Hello, I'm using DBI and DBD:ODBC in my perl script. I'm also using DBI::Const::GetInfoType. I was trying to get the database name using $dbh->get_info( $GetInfoType{SQL_DATABASE_NAME} ), and it returned 0, but $dbh->get_info( 16 ) worked! So I looked in lib/DBI/Const/GetInfo/ODBC.pm, an

Re: Truncating trailing spaces - looking for alternative solutions

2005-01-21 Thread Michael A Chase
Quoting Chad Terry <[EMAIL PROTECTED]>: > Having the notorious problem where trailing spaces are being truncated > from bind variables. I have found two solutions, one is to rtrim the > column in the SQL statement, the other is to set the type to CHAR with > bind_param. The problem is, I will be l

RE: Truncating trailing spaces - looking for alternative solution s

2005-01-21 Thread Rutherdale, Will
I don't understand the problem statement. Are you experiencing undesired truncation, or are you wishing to have strings truncated but not getting it? The ChopBlanks attribute on a database handle or statement handle controls truncating of fixed char columns, as documented in the DBI man page. I'

Truncating trailing spaces - looking for alternative solutions

2005-01-21 Thread Chad Terry
Greetings - Having the notorious problem where trailing spaces are being truncated from bind variables. I have found two solutions, one is to rtrim the column in the SQL statement, the other is to set the type to CHAR with bind_param. The problem is, I will be looking at changing up to 100 standalo

Re: DBD::Proxy breaking die within eval strangeness

2005-01-21 Thread Tim Bunce
On Fri, Jan 21, 2005 at 02:04:21PM -, Addison, Mark wrote: > From: Tim Bunce Sent: 20 January 2005 11:18 > > On Wed, Jan 19, 2005 at 05:37:42PM -, Addison, Mark wrote: > > > Hello, > > > > > > I'm having a very strange problem with DBD::Proxy and have ended > > > up with brain meltdown - s

encoding pragma aborts script

2005-01-21 Thread RH
Hi, I have an app which connects via DBI:DBD:CSV to a flat file. When I include pragma use encoding, the app aborts (message from OS and the script is killed). I found out that script is aborted during execute method of DBI. The DB file has only ASCII characters. I use pragma encoding to display l

RE: ORA-00600 internal error with DBD::Oracle 1.16

2005-01-21 Thread Reidy, Ron
Well, for starters, 'TYPE' is a reserved word (select keyword from v$reserved_words). Also, this is a known bug (metalink note 3612581.8). - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: LEROY Jean-Louis [mailto:[EMAIL PROTECTED] Sent: Friday, Januar

RE: DBD::Proxy breaking die within eval strangeness

2005-01-21 Thread Addison, Mark
From: Tim Bunce Sent: 20 January 2005 11:18 > On Wed, Jan 19, 2005 at 05:37:42PM -, Addison, Mark wrote: > > Hello, > > > > I'm having a very strange problem with DBD::Proxy and have ended > > up with brain meltdown - so now its your turn ;-) > > Here's a patch... Excellent, thanks very much

Re: how to connect postgres database

2005-01-21 Thread Hardy Merrill
Like Michael has nicely suggested to you twice now, 1. read the documentation, and after you've read the documentation, 2. try to do a connect yourself using examples in the documentation, and *then* if you still have problems, 3. post a message to dbi-users@perl.org, and in your messa

Re: how to connect postgres database

2005-01-21 Thread Michael A Chase tech
On 01/21/2005 06:59 AM, sudheer raghav said: am new to perl. how to connect postgresql database to perl. I replied to an identical message from you dated 01/17/2005 11:43 PM with: = Please look at http://www.catb.org/~esr/faqs/smart-questions.html . For DBI, http://search.cpan.org/~timb/DB

Re: ORA-00600 internal error with DBD::Oracle 1.16

2005-01-21 Thread Alexandru STAN
Hello, same problem here, solved using DBD-Oracle 1.15 Attention, my config : Win, perl 5.8.3, dbi 1.43 (DBI/DBD downloaded from esoftmatic) Regards, Alex LEROY Jean-Louis wrote: Hello, the following program: use strict; use DBI; my $dbh = DBI->connect(qw( dbi:Oracle: T3_JLL

Re: ORA-00600 internal error with DBD::Oracle 1.16

2005-01-21 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Jan 21, 2005 at 11:55:10AM +0100, LEROY Jean-Louis wrote: > DBD::Oracle::st execute failed: ORA-00600: internal error code, > arguments: [kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error > possibly near <*> indicator at

Re: ORA-00600 internal error with DBD::Oracle 1.16

2005-01-21 Thread Martin Hall
Jean-Louis, I would check with Oracle Support. This sounds like a known issue on the database. Martin LEROY Jean-Louis wrote: Hello, the following program: use strict; use DBI; my $dbh = DBI->connect(qw( dbi:Oracle: T3_JLL T3_JLL ), { PrintError => 0 }); $dbh->

ORA-00600 internal error with DBD::Oracle 1.16

2005-01-21 Thread LEROY Jean-Louis
Hello, the following program: use strict; use DBI; my $dbh = DBI->connect(qw( dbi:Oracle: T3_JLL T3_JLL ), { PrintError => 0 }); $dbh->do(q{DROP TABLE Person}); $dbh->disconnect; $dbh = DBI->connect(qw( dbi:Oracle: T3_JLL T3_JLL ), { PrintError =>