dbih_get_attr_k: assertion failed

2010-09-21 Thread Mara
Hi, I'm using DBI to connect to an Oracle 9i database. After connect, prepare and execute of an 'update' statement, the following $sth->fetchrow_hashref("NAME_lc") failes with DBI.xs:2001: dbih_get_attr_k: assertion »i == (const SV *) (name_av))->sv_flags & 0x0080)) ? Perl_mg_size(my_pe

RE: DBI interfacing with Mysql

2010-09-21 Thread SUNANDA SURYA KUMARI Y (ssuryaku)
Hi, I am facing problem with the interfacing of Mysql with perl module . It is showing me the following output. "install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Perl64/site/lib C:/Perl64/lib .) at (eval 5) line 3. Perhaps the DBD::mysql perl module ha

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
Thanx for you concern, the problem was with my installation. I have reinstalled everything system-wide perl-related, made the symlinks check, and reinstalled DBI and DBD::Pg, now all is fine. Thank you again! Yours Laslo On Tue, Sep 21, 2010 at 6:59 PM, Laslo Forro wrote: > I do not have DBI_DS

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
I do not have DBI_DSN set but I use "dbi:Pg:database=whatever". I receive no error message, simply nothing. I am digging deeper for DBI or Pg - do not know yet - drops a segfault in a tested piece of code, so perhaps the problem is somewhere in the dark corners of the Earth. On Tue, Sep 21, 2010

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > No, it doesn't work even after connecting the db. > > DBI: 1.614 > DBD::Pg: 2.17 > Postgresql: 8.4.4 What error does it give? Are you sure that your environment parameters are correct (e.g. DBI_DSN)? You might try specifying the information

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
No, it doesn't work even after connecting the db. DBI: 1.614 DBD::Pg: 2.17 installed locally in user's path via CPANP. Postgresql: 8.4.4 On Mon, Sep 20, 2010 at 6:15 PM, Greg Sabino Mullane wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > > > However, this piece of code give

Re: dbi transactions error handling

2010-09-21 Thread Paolo Lunazzi
Ok, now I understand where is my mistake. I set $dbh->{RaiseError} = 1 after declaring the statements $sql_live and $sql_dwh so these have the original value of RaiseError. In this case I have to modify the property of the single statements. Thanks, PL On Sep 20, 7:11 pm, imhar...@nuskin.com (Ian

Re: dbi transactions error handling

2010-09-21 Thread Paolo Lunazzi
Thanks for your solution. Your code works well but I don't understand why in my example eval doesn't catch the error and why, even in your example, with PrintError = 0 I get on output all the warnings of statements failed. Transactions section in DBI documentation recommends to use RaiseError and e