Search Discussions

52 discussions - 175 posts

  • Hi, In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look at $sth- {PRECISION} to retrieve the lengths of varchar2 columns for a given table. I'm now testing perl 5.8.7, ...
    Eric LenioEric Lenio
    Oct 13, 2005 at 5:15 am
    Oct 26, 2005 at 3:26 pm
  • I have the following sql insert statement in a file: INSERT INTO message(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,SHA1) VALUES('2005-Oct-18 11:53:21','pkitest.wellsfargo.com','auth ...
    Ward P FontenotWard P Fontenot
    Oct 24, 2005 at 6:01 pm
    Oct 28, 2005 at 11:07 am
  • Hi Folks I can't get last_insert_id() to work with Oracle. OS: GNU/Linux DBI: V 1.48 Oracle: 9.2.0 Demo (to save you typing): http://savage.net.au/last.pl I've tried various values for catalog and ...
    Ron SavageRon Savage
    Oct 6, 2005 at 10:32 am
    Oct 6, 2005 at 11:50 pm
  • Hi.... I have a fresh compile of Perl 5.8.7, DBI-1.48, SQL-Statement 1.15, AnyData-0.10 and DBD-AnyData-0.08 on AIX 5.2. When running a script using DBD-AnyData, I always get the error message 'DBI ...
    Michael FinkenMichael Finken
    Oct 10, 2005 at 12:41 pm
    Oct 16, 2005 at 8:25 pm
  • I am going to investigate more, but I thought I would post the question to see if anyone has run into this problem. I have co-workers that connecting to a remote Oracle DB (10.1), I compiled ...
    Scott T. HildrethScott T. Hildreth
    Oct 20, 2005 at 7:07 pm
    Dec 10, 2005 at 11:36 pm
  • Hello, is it possible to switch a dbi-connection between read-only and writable? Thank you, Gert
    Oct 14, 2005 at 3:15 pm
    Oct 24, 2005 at 6:28 pm
  • I am desperately trying to install DBD-Oracle on my UNIX system. No matter what I try I get the error : ceon3@suomp84b ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd ...
    David SawyerDavid Sawyer
    Oct 21, 2005 at 3:01 pm
    Oct 21, 2005 at 5:23 pm
  • Hi Everyone, I am trying to connect to an Oracle Database . Previously, I was using perl DBI and DBD:;Orcacle for this purpose. But now when I had installed an oracle client on my machine , I m ...
    Gupta, RazatGupta, Razat
    Oct 18, 2005 at 7:06 am
    Oct 18, 2005 at 8:22 pm
  • Hello, I have a question about using DBD::DBM in MLDBM mode: does anyone know whether it works with hashrefs as values, or just arrayrefs? Reading the docs and trying the module leads me to believe ...
    Ryan TateRyan Tate
    Oct 13, 2005 at 5:11 pm
    Oct 15, 2005 at 12:05 am
  • Hi. We have some Perl DBI scripts and have been running them on a Perl compiled with threading disabled. (I.e. perl -V gives ...usethreads=undef...). I also have another environment where Perl is ...
    Rutherdale, WillRutherdale, Will
    Oct 6, 2005 at 2:04 pm
    Oct 7, 2005 at 4:21 pm
  • I am currently having a problem calling a stored procedure on an iSeries. DBD::ODBC::st execute failed: [unixODBC][IBM][iSeries Access ODBC Driver]Error in assignment. (SQL-22018)(DBD: ...
    Stephen MoreStephen More
    Oct 12, 2005 at 6:30 pm
    Oct 13, 2005 at 11:11 pm
  • I've read all the threads out there on this but am not sure if there's a known general solution or not. We have a table with one CLOB and a number of other large VARCHAR2 columns. The VARCHAR2 ...
    Steve SapovitsSteve Sapovits
    Oct 28, 2005 at 1:50 pm
    Nov 2, 2005 at 1:20 am
  • Heya DBI-Users Can anyone help a DBI::Statement newbie with the following problems: 1. When parsing a SQL string, is there a preferred way for initially testing whether the statement did or did not ...
    John CougarJohn Cougar
    Oct 26, 2005 at 6:02 am
    Oct 27, 2005 at 1:44 am
  • i have to setup a dbd::informix without being able to create a test db. is this possible? basically everything looks like its working great (everything is compiling fine until it tries to connect to ...
    Matthew LenzMatthew Lenz
    Oct 21, 2005 at 6:37 pm
    Oct 25, 2005 at 5:10 am
  • While installing a module of perl on Solaris box. I am getting some problem. I have downloaded DBI.1.48.tar.gz Untar it. I have run the command " perl Makefile.pl" - OK " make " - shows some error ...
    Gupta, RazatGupta, Razat
    Oct 17, 2005 at 6:32 am
    Oct 17, 2005 at 12:08 pm
  • Hi! I'm using perl to access Oracle database. Everything is going well, but now I have a question about using CursorName. I was searching on the net for examples without success how to use cursors ...
    Nardin, SimonNardin, Simon
    Oct 11, 2005 at 8:05 am
    Oct 12, 2005 at 8:53 pm
  • Hi I've written a CGI script (not mod_perl) and am looking to use connect_cached to improve connection times. However, I have a couple of questions. Does it work in a non-persistent environment? I ...
    Dan HorneDan Horne
    Oct 31, 2005 at 7:57 pm
    Oct 31, 2005 at 9:05 pm
  • I have a Win32::OLE code, like bellow, running to get and parse a DBCC SHOWCONTIG, and a catch the result of DBCC by SQL messages errors. <code use Win32::OLE qw(in); use Win32::OLE::Const; my ...
    Solli Moreira HonorioSolli Moreira Honorio
    Oct 31, 2005 at 5:16 pm
    Oct 31, 2005 at 8:53 pm
  • I have multiple mod_perl applications running within one Apache instance. For most of these applications, I want to use Apache::DBI, but I want to disable it for just one. According to various Web ...
    Ted BehlingTed Behling
    Oct 21, 2005 at 4:58 pm
    Oct 27, 2005 at 5:32 am
  • I login to my remote mysql databases, using perl, this way: sub ConnectToDB { my $host_name = "";# Ip Address Here my $db_name = "DataBaseName"; # Database Name to connect to my $dsn = ...
    Oct 23, 2005 at 6:36 am
    Oct 25, 2005 at 1:44 pm
  • Howdy, I seem to have encountered an odd quirk somewhere when using DBI against an Oracle 10g database. Here's the situation. I'm taking the following object, serializing using Storable.pm, and ...
    Chris FuhrmanChris Fuhrman
    Oct 20, 2005 at 4:10 pm
    Oct 21, 2005 at 1:13 pm
  • DBI docs say: The ErrCount attribute was added in DBI 1.41. Older drivers may not have been updated to use set_err() to record errors and so this attribute may not be incremented when using them. ...
    Adriano FerreiraAdriano Ferreira
    Oct 13, 2005 at 8:49 pm
    Oct 14, 2005 at 4:02 pm
  • Hello Everyone, I m new to perl. I am stuck to some point. Our administrator have installed a module called DBI.pm in /DBI-1.48. Now when I try to run a script as : Perl -e "use DBI"; It will ...
    Gupta, RazatGupta, Razat
    Oct 10, 2005 at 5:36 am
    Oct 10, 2005 at 9:01 am
  • Hi, I have some trouble with the new SQL::Statement 1.14 when using a DBI:CSV database and bind values. Please have a look at these few lines: ~~~ #!/usr/bin/perl -w use strict; use DBI; my $dbh=DBI- ...
    Steffen G.Steffen G.
    Oct 7, 2005 at 7:56 pm
    Oct 8, 2005 at 7:18 am
  • Hello, I currently have Perl 5.6.1 and DBD-DB2 .76 installed on my Windows NT machine and everything works wonderfully. I would like to upgrade the DBD-DB2 to .78, but am having some difficulties. I ...
    Trent OhannessianTrent Ohannessian
    Oct 7, 2005 at 4:14 pm
    Oct 7, 2005 at 6:17 pm
  • The following code produces this error - ORA-01026 - after 2,000 inserts... Any help or suggestions will be greatly appreciated. &MyStd_Titles('Load Case', 30); my $sth_new_ref = $dbh- ...
    Moon, JohnMoon, John
    Oct 5, 2005 at 5:46 pm
    Oct 7, 2005 at 4:19 pm
  • Dear Jay, the result remains unchanged: perl Makefile.PL -m /usr/local/oracle/instantclient_10_2/demo/demo.mk Using DBI 1.48 (for perl 5.008003 on i386-linux-thread-multi) installed in ...
    Piet paaltjensPiet paaltjens
    Oct 31, 2005 at 11:14 pm
    Nov 1, 2005 at 1:48 pm
  • I have a strange problem with mysql 4.1 (innodb engine) and DBD::mysql 2.9006: A dbh- begin_work immediately after a dbh- commit fails with the error "Already in a transaction". A level 2 trace shows ...
    Peter J. HolzerPeter J. Holzer
    Oct 28, 2005 at 4:17 pm
    Oct 28, 2005 at 5:12 pm
  • Hello, I have an Oracle 9iR2 , ActivePerl 5.8.7. I downloaded DBI First, and DBD::Oracle 1.16 on the site Active PPM. I have an error : There is no oracle client libraries currently available for ...
    Pascal VILTARDPascal VILTARD
    Oct 26, 2005 at 1:37 pm
    Oct 26, 2005 at 3:02 pm
  • For those of you that use MySQL, this should be welcome news, that version 5.0.x is now officially stable, at 5.0.15. Speaking just personally, the recommended minimum versions of certain database ...
    Darren DuncanDarren Duncan
    Oct 24, 2005 at 10:08 pm
    Oct 25, 2005 at 9:52 am
  • Dear Jay (Strauss), following your advise this is what happens now: perl Makefile.PL -m /usr/lib/oracle/ Multiple copies of Driver.xst found in: ...
    Piet paaltjensPiet paaltjens
    Oct 21, 2005 at 10:11 pm
    Oct 22, 2005 at 1:55 pm
  • Script is below all this, and it is being performed on RHEL V3. The garbled field is a SHA1 blob computed from the FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE fields. With the DBI commands commented ...
    Ward P FontenotWard P Fontenot
    Oct 20, 2005 at 9:57 pm
    Oct 21, 2005 at 9:48 am
  • Dear Tim, I've just downloaded and tested the Oracle 10 Instant client software, including SQL*Plus. This appears to work well, with ORACLE_HOME, LD_LIBRARY_PATH and PATH settings. However when I try ...
    Piet paaltjensPiet paaltjens
    Oct 19, 2005 at 10:16 am
    Oct 20, 2005 at 1:34 pm
  • From: Tim Bunce Sent: Friday, October 07, 2005 12:19 PM To: Jared Still Cc: Moon, John; 'dbi-users@perl.org' Subject: Re: Execute failed: ORA-01026: multiple buffers of size 4000 in the bind list ...
    Moon, JohnMoon, John
    Oct 13, 2005 at 11:35 am
    Oct 13, 2005 at 4:37 pm
  • I was running DBI on my machine and it was fine. I was accessing remote Oracle servers using DBD::ORACLE. But when I had installed Oracle client on my machine . I am not able to connect to any of the ...
    Gupta, RazatGupta, Razat
    Oct 10, 2005 at 1:09 pm
    Oct 10, 2005 at 3:02 pm
  • Hi EveryOne, I have a query related to Oraperl. Actually , I have a script which is creating a connection to an Oracle database. The connection code is : &ora_login('','/',''); What I know is that ...
    Gupta, RazatGupta, Razat
    Oct 7, 2005 at 5:36 am
    Oct 7, 2005 at 10:30 pm
  • file: $CPAN/authors/id/T/TI/TIMB/JDBC-0.01.tar.gz size: 1966505 bytes md5: a6d17bd7fedf96ebc633a2807c512fdf There's no particular forum for discussion related to this yet. In the short term the ...
    Tim BunceTim Bunce
    Oct 4, 2005 at 10:46 pm
    Oct 5, 2005 at 6:40 pm
  • 2005-09-30 Darren Duncan <perl@DarrenDuncan.net -------------------------------------------------- I would like to acknowledge that, despite all the good things that have come out of it, I have had ...
    Darren DuncanDarren Duncan
    Oct 1, 2005 at 5:13 am
    Oct 1, 2005 at 8:09 am
  • Dear all, I have Perl script that is supposed to reconnect after loosing connection a MySQL database. For the life of me I can't see why it won't reconnect. I am not a Perl programmer but the ...
    Nigel SweetmanNigel Sweetman
    Oct 31, 2005 at 5:02 am
    Oct 31, 2005 at 5:02 am
  • Hello I try to install DBD::Oracle with ppm. I use ActivePerl on Window$. C:\ perl -v This is perl, v5.8.7 built for MSWin32-x86-multi-thread (with 7 registered patches, see perl -V for more detail) ...
    Pascal VILTARDPascal VILTARD
    Oct 26, 2005 at 9:44 am
    Oct 26, 2005 at 9:44 am
  • Hi, I'm trying to keep a count of how many times a record was changed. In the MySQL command line this works perfectly: UPDATE MyStuff SET cnt=cnt+1,first=7 where last=8; Field cnt's value is ...
    Nico van der DussenNico van der Dussen
    Oct 22, 2005 at 10:33 am
    Oct 22, 2005 at 10:33 am
  • In message <20051021172300.15763.qmail@web31309.mail.mud.yahoo.com , joe bayer writes: We encountered this problem with an application we deliver for Windows. The solution was to unset PERL5LIB in ...
    John D GroenveldJohn D Groenveld
    Oct 21, 2005 at 7:38 pm
    Oct 21, 2005 at 7:38 pm
  • Actually this seems an issue with SQLite 3.2. DBD::SQLite 1.09 uses 3.2.2. And it is reproducible with the Java wrapper over 3.2.1. A statement like SELECT 'a which should be a syntax error, doubles ...
    Adriano FerreiraAdriano Ferreira
    Oct 21, 2005 at 3:02 pm
    Oct 21, 2005 at 3:02 pm
  • While developing, I gave DBD::SQLite a bad SQL statement like "select 'eek" (quoted string not terminated). It worked and gave a weird answer. Is that something I should be expecting? Some oddity of ...
    Adriano FerreiraAdriano Ferreira
    Oct 20, 2005 at 4:27 pm
    Oct 20, 2005 at 4:27 pm
  • Hi, I am using DBI version 1.48 and DBD::mysql 3.0002 to run a very simple script (the original one is much bigger, this is just to show the problem), and I get an error when trying to select data, ...
    Daniel RiosDaniel Rios
    Oct 20, 2005 at 11:56 am
    Oct 20, 2005 at 11:56 am
  • Hi. Using Perl v5.8.5 with DBI-1.47 on Linux. I've developed some Perl scripts which are executed by crons and handle data by using MySQL. I want to optimize my server's memory use and would like to ...
    thomas Armstrongthomas Armstrong
    Oct 19, 2005 at 10:37 am
    Oct 19, 2005 at 10:37 am
  • Please disregard. The code is fine. It was a freakin data problem with my test DB. -----Original Message----- From: Matthew Dougerty Sent: Sunday, October 16, 2005 3:25 PM To: dbi-users@perl.org ...
    Matthew DoughertyMatthew Dougherty
    Oct 17, 2005 at 6:26 am
    Oct 17, 2005 at 6:26 am
  • 0


    Hi Everyone, I have installed ActiveStatePerl 5.6.1 in my Solaris box. I want to confirm one thing : is it possible to install any module of perl using "ppm" available in Active Perl. For windows ,I ...
    Gupta, RazatGupta, Razat
    Oct 17, 2005 at 5:47 am
    Oct 17, 2005 at 5:47 am
  • Hello! http://bugs.mysql.com/bug.php?id=2658 Have somebody found solution for above bug, as I will code myself the solution, but I am asking here to not reinvent the wheel :-) Problem is following: ...
    Speedy GonsalesSpeedy Gonsales
    Oct 11, 2005 at 8:04 am
    Oct 11, 2005 at 8:04 am
  • Hello All, I am trying to insert data in TEXT field in Latin1 PostgreSQL database using Perl 5.8.4, DBI 1.48, DBD::Pg 1.42 on Debian (kernel 2.6.8). The table name ($tblname) I get from XML parser ...
    Zhivko DuchevZhivko Duchev
    Oct 10, 2005 at 1:48 pm
    Oct 10, 2005 at 1:48 pm
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
groupdbi-users @

61 users for October 2005

Tim Bunce: 22 posts Ron Savage: 9 posts Eric Lenio: 8 posts Gupta, Razat: 8 posts Jeff Zucker: 6 posts Reidy, Ron: 6 posts Steve Baldwin: 5 posts Ward P Fontenot: 4 posts Adriano Ferreira: 4 posts Jared Still: 4 posts Jeff Urlwin: 4 posts Matthew Dougherty: 4 posts Ryan Tate: 4 posts Ted Behling: 4 posts Dan Scott: 3 posts Darren Duncan: 3 posts Jay Strauss: 3 posts Jonathan Leffler: 3 posts Matthew Lenz: 3 posts Peter J. Holzer: 3 posts
show more