FAQ

Perl > dbi-users > April 2005

Search Discussions

85 discussions - 369 posts

  • Hi. I'm working on a project using DBD::Oracle 1.16, DBI 1.43, Perl 5.6, WinXP, and Oracle 8.1.7.4. My script runs through a loop many times, and each time through it calls two PL/SQL stored procs ...
    Michael StyerMichael Styer
    Apr 20, 2005 at 5:40 pm
    May 16, 2005 at 3:18 pm
  • Hi all, This is not direct perl question, but it is database related. I am on freebsd, using mysql, and thinking about storing pictures in database. But someone tolds me, that is faster to have only ...
    Ing . Branislav GerzoIng . Branislav Gerzo
    Apr 9, 2005 at 10:47 pm
    May 23, 2005 at 1:57 am
  • I was able to remove those errors by installing OCI libraries but now I am facing the following problem. /usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh collect2: ld returned 1 exit ...
    Hemanth KumarHemanth Kumar
    Apr 19, 2005 at 6:14 pm
    May 3, 2005 at 4:14 am
  • Hi, I have fresh install Solaris 9. We have some perl scripts to run. I am getting "Can't locate DBI.pm" error to execute the file. We access oracle 9 from this perl script. Can some one help me to ...
    Chekuri, LalithaChekuri, Lalitha
    Apr 26, 2005 at 4:10 pm
    Apr 29, 2005 at 1:30 am
  • What is bind_param() supposed to do when given invalid data, i.e. data that doesn't match the specified type? I've just come across a nasty situation in which a supposed "real number", output by a ...
    Steve HaySteve Hay
    Apr 4, 2005 at 2:40 pm
    Apr 7, 2005 at 4:25 pm
  • This is my hash structure: "Veterans Day" = { date = '20051111', type = 'US', federal = 'true', active = 'true', }, Would I just use a placeholder (?) in my statement and pass it in via that? It will ...
    RobertRobert
    Apr 21, 2005 at 1:36 pm
    May 23, 2005 at 3:27 am
  • Hi, Does anyone have any idea what is up with Microsoft Access and its ridiculous Date/Time formatting options? It doesn't seem to matter what format I attempt to insert with. The directory and db ...
    RobbRobb
    Apr 13, 2005 at 6:34 am
    Apr 15, 2005 at 11:45 am
  • Hi, FreeBSD-6.0-current/i386 httpd2/apr/apr-util/modperl2 from SVN trunk w/ worker mpm apr with threads bleedperl w/ ithreads SVN of DBI(964) make test TEST_VERBOSE=1 is attached snipped for only ...
    Philip M. GollucciPhilip M. Gollucci
    Apr 10, 2005 at 12:57 am
    Apr 12, 2005 at 11:59 am
  • Further... I thought I could use fetchrow_arrayref and push an array of arrays. The DBI docs say: "Note that the same array reference is returned for each fetch, so don't store the reference and then ...
    Jonathan ManginJonathan Mangin
    Apr 26, 2005 at 8:13 pm
    Apr 27, 2005 at 4:02 pm
  • Hi all I am new to perl just (1 1/2 month experience.). I am developing perl script which connects to oracle database and selects rows from a (x) table and then inserts them into its corresponding ...
    Vamsi_DoddapaneniVamsi_Doddapaneni
    Apr 14, 2005 at 2:09 pm
    Apr 15, 2005 at 2:19 pm
  • Hi, I'm using DBD::DBM, and the queries I think should be quick and based on the dbm key are taking forever and my strace output confirms that the whole dbm file is being searched. In the module ...
    Jim LambertJim Lambert
    Apr 7, 2005 at 9:41 pm
    Apr 10, 2005 at 1:51 am
  • Hi, I'm calling an external Stored Procedure written in PL/SQL that includes one input argument and an output argument that is a REF CURSOR. When I run the code I get the error's indicated below. Any ...
    Denesa K ShawDenesa K Shaw
    Apr 14, 2005 at 7:01 pm
    Apr 18, 2005 at 5:10 pm
  • Hi, i've 2 select query. the first one is like my $sql = $dbh- prepare(q{select * from test}); the second: my $sql1 = $dbh- prepare(q{select * from test1 where test1.row = ?}) $sql- execute(); ...
    Xaver bitonXaver biton
    Apr 7, 2005 at 11:06 am
    Apr 12, 2005 at 7:05 pm
  • I'm using DBI and DBD::Oracle. I'd like to be able to describe a table, but 'describe table' fails no matter how I try to pass it to DBI. I feel certain that this is a FAQ and so apologise in ...
    Mike ScottMike Scott
    Apr 18, 2005 at 5:49 pm
    May 23, 2005 at 2:05 am
  • I am trying to get the index for a state and when I do: my $sql1 = "SELECT id, name_short, name_long FROM states WHERE name_short='PA"; $sth1 = $dbh- prepare($sql1); # $sth1- execute(); It works. But ...
    Robert A. RawlinsonRobert A. Rawlinson
    Apr 2, 2005 at 6:11 pm
    Apr 4, 2005 at 4:48 am
  • I am trying to connect to an MS SQL Server database, running on a Win2k server, from a Solaris 5.8 system using Perl 5.6.1. I have installed DBI and Bundle::DBD, but I can't get a connection. I have ...
    Mark VaughanMark Vaughan
    Apr 28, 2005 at 6:31 pm
    May 9, 2005 at 2:47 pm
  • Hi all, I'm running into an interesting problem with a database error that occurs on one statement handle and seems to affect another handle despite using eval {...} and RaiseError. Perhaps example ...
    Joel StevensonJoel Stevenson
    Apr 21, 2005 at 4:04 pm
    Apr 26, 2005 at 1:21 am
  • Thanks for getting back to me so fast. We went back and tried to eliminate a few variables and went through the readme files once again. I did a clean compile of Perl 5.8.6 and all modules. We still ...
    Cory CoxCory Cox
    Apr 7, 2005 at 1:02 pm
    Apr 19, 2005 at 2:44 am
  • Hi Friends, I am using oracle database and I have column of long data type. I insert the data into this column thru perl script. If the inserted data exceeds 4000 chars, it is giving me the following ...
    MallikMallik
    Apr 11, 2005 at 11:12 am
    Apr 12, 2005 at 8:14 pm
  • Hi, this is my test script: use DBI; use encoding 'utf-8'; use strict; use warnings; my ($dbh,$sth,$col1,@test); $dbh = DBI- connect("DBI:CSV:csv_sep_char=\\|",{RaiseError = 1}) or die "Cannot ...
    Radomir HejlRadomir Hejl
    Apr 23, 2005 at 7:44 pm
    May 15, 2005 at 7:18 pm
  • Dear DBI/DBD::mysql developers, DBD::mysql 2.9007 and 2.9015_3 are now available via CPAN! * DBD::mysql 2.9007 is the production release and is available as the default version using CPAN shell, or ...
    Patrick GalbraithPatrick Galbraith
    Apr 28, 2005 at 1:48 am
    Apr 28, 2005 at 4:31 pm
  • I had a slight problem while installing DBD::Oracle 1.16 on a 64-bit Perl 5.8.5 running on a Solaris 9 system with Oracle 9i. "perl Makefile.PL" tried to use the 32-bit Oracle libraries. The Oracle 9 ...
    James D. WhiteJames D. White
    Apr 19, 2005 at 9:31 pm
    Apr 26, 2005 at 2:19 pm
  • Hi , I am facing poblem in connecting a database thru perl program Here are the details about the packages which i installed in my Windows machine ...
    Jagatheesh RamakrishnanJagatheesh Ramakrishnan
    Apr 21, 2005 at 2:41 pm
    Apr 22, 2005 at 12:32 pm
  • Dear perl dbi team, I need a windows binary for the DBD-Oracle, but it seems the esoftmatic link is invalid. Do you know any different sources or whether the esoftmatic is only temporarily ...
    Christian BraeunerChristian Braeuner
    Apr 11, 2005 at 6:19 pm
    Apr 14, 2005 at 12:00 pm
  • Hi all, This is probably a more DB oriented question, but it came out of the DBI. I posted a question and have tried several solutions on how to open up an MS Access DB from the DBI::ODBC but so far ...
    Moreno, JavierMoreno, Javier
    Apr 8, 2005 at 8:44 pm
    Apr 11, 2005 at 8:19 pm
  • Why not install the free Windows SQL Server Express 2005? http://lab.msdn.microsoft.com/express/sql/ With features: http://lab.msdn.microsoft.com/express/sql/Features/default.aspx There is a SQL2000 ...
    Moosmann, JamesMoosmann, James
    Apr 1, 2005 at 2:45 pm
    Apr 1, 2005 at 3:52 pm
  • I have recently come across a problem with cPanel/Fedora and DBI. After a recent update of cpanel the exim stats script stopped working, and produces the following error: Starting eximstats: DBI ...
    WebmasterWebmaster
    Apr 27, 2005 at 2:07 pm
    Apr 27, 2005 at 11:30 pm
  • Hi, I have downloaded DBD-Oracle DBD-Oracle9-1.16-5.8.4.tar.gz from ftp.esoftmatic.com <ftp://ftp.esoftmatic.com/ website and unzipped it. Could you tell me how to install DBD-Oracle on Windows 2000 ...
    Wang, WeiliWang, Weili
    Apr 26, 2005 at 10:37 pm
    Apr 27, 2005 at 3:45 pm
  • Hi, When I install DBD::Oracle module, I get the following error. ============================= ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class: ELFCLASS64 ld: fatal: File ...
    PerlDiscuss - Perl Newsgroups andPerlDiscuss - Perl Newsgroups and
    Apr 26, 2005 at 10:54 am
    Apr 27, 2005 at 8:57 am
  • Help.. I have been struggling to get DBI to work on my server... Here is the code.. #! /usr/bin/perl #use strict; BEGIN { $ENV{SYBASE} = "/opt/sybase11.9.2"; } use DBI; print "Here's a list of DBI ...
    Desai, Anand (HP-GDIC)Desai, Anand (HP-GDIC)
    Apr 11, 2005 at 12:56 pm
    Apr 12, 2005 at 4:25 pm
  • hi - this behavior is not holding us back as its easy to work around, but its something that should be documented/clarified/fixed, since it can create extremely hard to track-down hangs. its also ...
    Mike bayerMike bayer
    Apr 5, 2005 at 9:47 pm
    Apr 6, 2005 at 11:30 pm
  • I've decided to start an experiment to see how much of a wheel I've remade when I released SQL::Routine and its friends. The results of it may end up being of practical use, or they may end up having ...
    Darren DuncanDarren Duncan
    Apr 5, 2005 at 4:16 am
    Apr 5, 2005 at 9:26 pm
  • Hello, I have a program in perl running on Linux, accessing a SQL Server database via ODBC. It runs fine. But yesterday, the process had been running for six days when suddenly, one specific select ...
    April BlumenstielApril Blumenstiel
    Apr 28, 2005 at 3:52 pm
    May 4, 2005 at 6:03 am
  • Hello all, I connect to MSSQL via ODBC, exist some method to get last inserted id? I read in DBI docs: For some drivers the value may only be available if placeholders have not been used (e.g., ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    Apr 29, 2005 at 1:08 pm
    May 2, 2005 at 6:57 am
  • Is there any way to bind a CLOB into the XMLType.createxml() call? The createXML has 4 different signatures, one is varchar2, one is clob. If the data is larger than 32k, I need to bind in a clob, ...
    Job MillerJob Miller
    Apr 28, 2005 at 11:50 am
    Apr 28, 2005 at 1:47 pm
  • Hi, I have stored en empty string in a varchar(255) column of a Sybase ASE. When I retrieve it via $r = $dbh- selectall_arrayref("select Value from Example where Id = 17"); then the following is ...
    Rainer J. H. BrandtRainer J. H. Brandt
    Apr 27, 2005 at 1:55 pm
    Apr 27, 2005 at 4:09 pm
  • Here is a patch to the pod documentation of DBD::Oracle-1.16. The patch alters the section headed 'Binding Cursors'. The patch: * corrects an error. When passing a cursor back from Perl to PL/SQL, ...
    Charles JardineCharles Jardine
    Apr 27, 2005 at 10:02 am
    Apr 27, 2005 at 3:00 pm
  • Hello, does anybody on this list use DBD::Chart? I have the problem that concerns modifying HTML imagemap elements. I have barchart on depts' costs. When I click on a bar I have dept's name in :X ...
    Wojciech PietronWojciech Pietron
    Apr 25, 2005 at 3:08 pm
    Apr 25, 2005 at 6:24 pm
  • Hi, I am getting data corruption when I attempt to run several processes in parallel when making changes to two tables. DBD version 1.16, DBI version 1.48, Linux 2.6, Oracle 9i. I am trying to select ...
    RKrisRKris
    Apr 23, 2005 at 3:31 pm
    Apr 25, 2005 at 2:17 pm
  • While I love programming in Perl, I am new at building and installing modules. After going through the aggravation of getting my PATH, INCLUDE and LIB set up correctly, and getting to first base with ...
    Budd_kopmanBudd_kopman
    Apr 23, 2005 at 4:52 pm
    Apr 25, 2005 at 12:32 pm
  • Hi, I've been using PERL and especially the DBI module for Oracle and now recently MySQL. I'm having trouble with getting DBD::MySQL in compiled form to work from Windows/XP. I really (being honest ...
    Roy NiemannRoy Niemann
    Apr 20, 2005 at 2:53 pm
    Apr 21, 2005 at 1:26 am
  • Hi All, I am having problem with spaces. I am loading data from a normalized schema into a denormalized table. Many of the fields I am copying originally come from free form fields and we don't ...
    Ian HarisayIan Harisay
    Apr 19, 2005 at 5:43 pm
    Apr 20, 2005 at 12:59 pm
  • I'm trying to find an open source version of an ODBC driver for Windows SQL Server. I have spent a lot of time looking around and there simply doesn't seem to be anything. I have located, downloaded ...
    Mark F. nettleinghamMark F. nettleingham
    Apr 12, 2005 at 8:28 pm
    Apr 13, 2005 at 3:50 am
  • Hello all, Well after I finally got DBI installed on Mac OS X I made a quick test script. I then tested it out from the terminal and debugged it. It works! I then tried it on my Apache server, same ...
    Bruce MartinBruce Martin
    Apr 12, 2005 at 9:39 am
    Apr 12, 2005 at 10:02 am
  • Does execute_array offer any performance improvement over execute inside of loop? -- Brandon
    Brandon MetcalfBrandon Metcalf
    Apr 8, 2005 at 5:24 pm
    Apr 8, 2005 at 5:42 pm
  • I am having a problem installing DBI giving me this error: gcc -c -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xdepend -DVERSION=\"1.48\" -DXS_VERSION=\"1.48\" -fPIC ...
    Daniel TekluDaniel Teklu
    Apr 29, 2005 at 9:11 pm
    Apr 29, 2005 at 9:20 pm
  • The load_dbnames() function does not handle tnsnames.ora files properly. It scans _the_ file looking for leading edge database connection names, but it doesn't honor the ifile directive. The ifile ...
    Mark S. DavisMark S. Davis
    Apr 26, 2005 at 3:27 pm
    Apr 27, 2005 at 1:27 am
  • Hello. I was having some strange problems with fetchall_arrayref in my code and thought I would share this with the list. The specific problem was when I was conducting multiple prepare/execute(s) ...
    Christopher HeidbrinkChristopher Heidbrink
    Apr 26, 2005 at 4:18 am
    Apr 26, 2005 at 4:35 am
  • Hello. I ran the BugReport for D t91udts.t. Everything seems ok except for that one test for udts. From the error I wonder if it has anything to do with the DBD::Informix or simply with this version ...
    ODELL, TODD E \(SWBT\)ODELL, TODD E \(SWBT\)
    Apr 25, 2005 at 4:31 pm
    Apr 25, 2005 at 7:50 pm
  • How do I pass an one parameter to a External Stored Procedure?
    Denesa K ShawDenesa K Shaw
    Apr 22, 2005 at 4:29 pm
    Apr 23, 2005 at 12:15 am
Apr 2005
12
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions85
posts369
users123
websitedbi.perl.org

123 users for April 2005

Tim Bunce: 23 posts Reidy, Ron: 21 posts Michael A Chase: 18 posts Ron Savage: 13 posts Michael Styer: 12 posts Amonotod: 11 posts Hemanth Kumar: 10 posts Jeff Urlwin: 10 posts Jonathan Leffler: 8 posts Philip M. Gollucci: 8 posts Darren Duncan: 7 posts Jeff Zucker: 7 posts Patrick Galbraith: 7 posts Steve Hay: 7 posts Charles Jardine: 6 posts Chekuri, Lalitha: 6 posts Denesa K Shaw: 6 posts Michael Nhan: 6 posts Steven Lembark: 6 posts Jim Lambert: 5 posts
show more
Archives