FAQ

Search Discussions

90 discussions - 317 posts

  • I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a local Oracle 9i database table and retrieve the data in the three small fields of its only two records. Why is the ...
    Paul ApplebyPaul Appleby
    Oct 18, 2004 at 1:03 am
    Oct 23, 2004 at 10:27 pm
  • I am using DBI and DBD-ODBC to connect to an MSSQL Server and this query gets an invalid cursor state: PRINT 'starting select' select count(*) from anytable PRINT 'finished' If I only run the PRINT ...
    Moosmann, JamesMoosmann, James
    Oct 18, 2004 at 10:46 pm
    Oct 20, 2004 at 7:55 am
  • Hi, I'm trying to run query like this: ........................... use DBI; use strict; $dbh = DBI- connect( "dbi:Oracle:$host_db", $host_user, $host_passwd, { AutoCommit = 1, RaiseError = 1, ...
    Ravi KongaraRavi Kongara
    Oct 22, 2004 at 7:31 pm
    Oct 26, 2004 at 10:40 pm
  • Hi, Recently we upgraded from DBD::Oracle v1.12 to DBD v1.15 as we had to upgrade to Oracle 9i. But there is some functionality difference I observerd in ora_open() function. (We are using Oraperl ...
    Mahadevan, ArunMahadevan, Arun
    Oct 8, 2004 at 4:12 pm
    Oct 11, 2004 at 5:47 pm
  • Hi, according the Oracle documantation: INSERT INTO a_table values (empty_blob()); Even better is to use the RETURNING clause (thereby eliminating a round trip that is necessary for the subsequent ...
    Silvio WankaSilvio Wanka
    Oct 8, 2004 at 11:37 am
    Oct 22, 2004 at 11:16 am
  • Hi, I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File. After the stored procedure executes, it returns an out parameter called out_v_RECV_FILE_NM. I have a perl script which ...
    Denesa K ShawDenesa K Shaw
    Oct 20, 2004 at 8:25 pm
    Oct 21, 2004 at 2:17 pm
  • I've seen several posting regarding problems people have seen on Linux with Oracle 9 client libraries and DBD::Oracle, causing an ORA-03113 end-of-file on communication channel error when querying ...
    Alan SparksAlan Sparks
    Oct 11, 2004 at 8:16 pm
    Oct 15, 2004 at 5:15 pm
  • I have been getting an annoying warning about dereferencing an unreferenced scalar. Sometimes it comes out in such a way that it misses $SIG{__WARN__} redirection. After much trial and error I ...
    Marc M. AdkinsMarc M. Adkins
    Oct 14, 2004 at 3:29 am
    Nov 9, 2004 at 2:27 am
  • Hello, I have a cgi application that works fine using DBD::Pg to insert/select data from a PostgreSQL using UTF-8 (database created as UNICODE). We have data in multiple languages stored, which has ...
    Susan CassidySusan Cassidy
    Oct 14, 2004 at 11:08 pm
    Oct 18, 2004 at 5:03 pm
  • Hi everyone, I have ChopBlanks on, but an empty char field from a Visual FoxPro table (char length 30) ends up as a single blank. Is there some rule that ChopBlanks leaves a single blank? Thanks for ...
    Stephen ToneyStephen Toney
    Oct 4, 2004 at 8:37 pm
    Oct 6, 2004 at 4:23 pm
  • Hi guys, Here is what's going on: 1. I am running the latest release of CygWin on a Windows XP machine. I am not running ActiveState Perl. 2. I installed DBI and tested it. Looks like it's working ...
    Vassilev, Lubomir G.Vassilev, Lubomir G.
    Oct 28, 2004 at 7:35 pm
    Oct 29, 2004 at 9:51 pm
  • DBI-1.45 requires Perl 5.006, I am running 5.005.03, which DBI version should I use? I am getting below error when I do $)- perl Makefile.PL Perl 5.006 required--this is only version 5.00503, stopped ...
    Das, ManojitDas, Manojit
    Oct 13, 2004 at 9:10 pm
    Oct 15, 2004 at 4:08 pm
  • Greetings DBI Users, I am having an intermittent problem which has increased in frequency. Googling the output doesn't provide any answers, or even evidence of other people with the same question. ...
    Sean McMillanSean McMillan
    Oct 6, 2004 at 8:47 pm
    Oct 12, 2004 at 8:58 pm
  • Perl DBI When I prepare a query with select a from b where c in (?) and send 'sjhd,'sdh' as paremeter to bind, its not working as desired. Whats the correct way of using prpared statements and ...
    Sunil A.V.Sunil A.V.
    Oct 29, 2004 at 11:15 pm
    Oct 30, 2004 at 1:34 am
  • This is not a Perl issue. There is an issue with PL/SQL proc - maybe some variable is too small for the data? Or did you change character sets? Or ...? ----------------- Ron Reidy Lead DBA Array ...
    Reidy, RonReidy, Ron
    Oct 28, 2004 at 8:28 pm
    Oct 29, 2004 at 10:14 am
  • Hi, Please clarifiy on the following. While I am trying to install perl DBI on Windows 2000 Professional, I am getting the following error after I executed nmake.exe ...
    Murthy PydikondalaMurthy Pydikondala
    Oct 20, 2004 at 5:47 am
    Oct 20, 2004 at 5:24 pm
  • Dear Marco, I thought I remembered seeing this before, and when I looked at my email archive at work, sure enough, on 2004-10-05 09:49 -07:00, I responded to your questions. Did you not receive the ...
    Jonathan LefflerJonathan Leffler
    Oct 11, 2004 at 11:21 pm
    Oct 20, 2004 at 4:00 pm
  • I get the following error when trying to build DBD::Informix with perl 5.8.5 on Solaris 9 12/03 s9s_u5wos_08b SPARC with INFORMIX-ESQL Version 9.51.UC3. I've built it successfully before on the same ...
    Tielman de VilliersTielman de Villiers
    Oct 8, 2004 at 1:49 pm
    Oct 10, 2004 at 6:16 am
  • Hi there, I have a problem with quoting of backslashes when using DBI:CSV. To be precise: I insert a string containing a backslash into my database, and when I read it out again, the backslash is ...
    Steffen G.Steffen G.
    Oct 24, 2004 at 9:28 am
    Oct 24, 2004 at 10:25 pm
  • My select looks like this: SELECT surname, first_name, msf810.email_address, msf810.employee_id FROM msf810, msf020, MSF829 WHERE msf810.employee_id = msf020.employee_id AND msf810.employee_id = ...
    RobertRobert
    Oct 19, 2004 at 5:36 pm
    Oct 21, 2004 at 1:08 pm
  • hey all, I'm missing a piece, I guess, in the install of DB2.. I have the libraries, etc. installed in /opt/IBM/db2/V8.1. I'm getting: Constants.xs:16:20: sqlcli.h: No such file or directory ...
    Edward PeschkoEdward Peschko
    Oct 12, 2004 at 7:35 pm
    Oct 14, 2004 at 7:19 pm
  • Anyone seen this before (and know how to work around it?) I get a segmentation fault under mod_perl...: dbd_st_execute SELECT (out0, lob0)... dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) ...
    Richard FoleyRichard Foley
    Oct 12, 2004 at 3:17 pm
    Oct 14, 2004 at 6:19 am
  • Henry, Have you tried any of these fixes? http://dev.mysql.com/doc/mysql/en/Old_client.html Are you sure you're running MySQL 4.1.5 because the 'upgrade client' error is typically caused by using a ...
    Elliot FielsteinElliot Fielstein
    Oct 11, 2004 at 5:40 pm
    Oct 12, 2004 at 3:25 pm
  • Please forgive me if this is a newbie question, but I have searched all over and can't seem to find the answer I am looking for. I am getting DataType mismatch errors when posting to a Lotus Notes DB ...
    Chris GehringChris Gehring
    Oct 7, 2004 at 8:36 pm
    Oct 8, 2004 at 4:43 pm
  • I'm having problems with a couple on tests. The bug report is below. Everything seems ok and most of the tests are alright but t60unlog, t91udts and t93lvarchar are partially failing. This is on an ...
    ODELL, TODD E \(SWBT\)ODELL, TODD E \(SWBT\)
    Oct 7, 2004 at 8:08 pm
    Oct 8, 2004 at 1:26 pm
  • Hi, I am experiencing a strange error with DBI. karthik@graf-spee:~/code/extremix/WFramework$ ./runtests t/conf.........ok t/exception....ok t/session......ok 2/9Had to create ...
    Karthik KrishnamurthyKarthik Krishnamurthy
    Oct 7, 2004 at 4:44 am
    Oct 8, 2004 at 9:28 am
  • I just saw a post from someone that was using Lotus Notes. Is there a Perl Module that interfaces to Lotus Notes?
    Richard J McWatersRichard J McWaters
    Oct 7, 2004 at 8:49 pm
    Oct 7, 2004 at 11:16 pm
  • Howdy, So, I'm trying to use execute_for_fetch, and according to the POD (provided I'm reading it correctly), I need an array of arrays, each of which will hold data for one column. Okay, no ...
    AmonotodAmonotod
    Oct 4, 2004 at 8:59 pm
    Oct 5, 2004 at 9:02 am
  • ----- Forwarded message from Denesa K Shaw <denesa.shaw@CenterPointEnergy.com ----- Delivered-To: tim.bunce@pobox.com X-SPF-Guess: pass (seems reasonable for denesa.shaw@CenterPointEnergy.com to mail ...
    Tim BunceTim Bunce
    Oct 28, 2004 at 9:14 pm
    Jan 28, 2005 at 12:36 pm
  • HI all, DBI on activestate perl 5.8.4 seems broken . Always the same D:\downloads\dbi ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBI.ppd -force Error: Failed to download URL ...
    Alessandro bonviciniAlessandro bonvicini
    Oct 27, 2004 at 11:12 am
    Oct 28, 2004 at 5:40 pm
  • We make extensive use of named bind params in our apps (our DB is Oracle). I just tried running a test program over DBD::Proxy and found it barfs on these. Here is the code in DBD::Proxy that doesn't ...
    Steve BaldwinSteve Baldwin
    Oct 21, 2004 at 9:34 pm
    Oct 21, 2004 at 11:23 pm
  • I'd like to get a list of open source perl (DBI based) database interface GUIs for unix (Tk/Gtk etc). If people could send me (off-list) details of any they know I'll summarize back to the list. ...
    Tim BunceTim Bunce
    Oct 18, 2004 at 4:09 pm
    Oct 18, 2004 at 10:34 pm
  • I am sinking like the Titanic trying to install this module. I have RTFM'd till my head spins and still fail. Any help appreciated. Let me know what information to provide if needed. Thanks, Roy Brown
    Roy BrownRoy Brown
    Oct 13, 2004 at 3:44 pm
    Oct 14, 2004 at 4:44 pm
  • Hello all, Although DBI is great, is there some other sort of DBD module that can connect to an Oracle database without needing to install Oracle's pile of steaming code? I'd like something ...
    Joseph BruniJoseph Bruni
    Oct 12, 2004 at 9:36 pm
    Oct 13, 2004 at 6:07 pm
  • Hi All, I am trying to install DBI and DBD::Oracle module in our system. We have osname=solaris, osvers=2.8 Perl : version 5.005_03 Would you please tell me which DBI and DBD::Oracle version I have ...
    Das, ManojitDas, Manojit
    Oct 12, 2004 at 7:54 pm
    Oct 12, 2004 at 9:00 pm
  • Hello, I'm trying to link the DBD-Oracle module to the Oracle 10g client library on OS X (10.3.5) and the "nmedit" script does not seem to work yet. Are there any plans on updating the DBD-Oracle ...
    Joseph BruniJoseph Bruni
    Oct 6, 2004 at 8:29 pm
    Oct 7, 2004 at 4:55 pm
  • When I run the command: perl Makefile.pl in order to compile the DBD::SQLite module, I'm getting this error: Undefined subroutine &DBI::DBD::unixify called at ...
    Fitzpatrick, PaulFitzpatrick, Paul
    Oct 7, 2004 at 12:23 am
    Oct 7, 2004 at 3:26 pm
  • ## Cc: Tim.Bunce@pobox.com On "make test", I get the following. I assume that dbi uses a dll? Is that right? Since the Oracle.dll is definitely where the install driver is located, I assume that the ...
    DavidDavid
    Oct 4, 2004 at 1:18 pm
    Oct 7, 2004 at 1:49 pm
  • ----- Forwarded message from Rachita <rachita.sachdeva@bhartitelesoft.com ----- Delivered-To: tim.bunce@pobox.com X-Pobox-Antispam: Require PTR Record returned DENY: 202.56.229.147 has no PTR record ...
    Tim BunceTim Bunce
    Oct 28, 2004 at 9:14 pm
    Nov 2, 2004 at 3:36 pm
  • This appears to be a known problem, see http://groups.google.com/groups?hl=en&lr=&q=test.pl+uninitialized+%22dbi+onl y%22: ### What's that warning? printf "%5d NullP sth/s perl %8s %s (%s %s ...
    Repko, DavidRepko, David
    Oct 29, 2004 at 2:48 pm
    Oct 31, 2004 at 3:15 pm
  • Hi, Hopefully someone can explain this to me. The attached script causes an object's destructor not to be called! This happens when a non-existing hash key is bound to a DBI statement handle with ...
    Kurt George GjerdeKurt George Gjerde
    Oct 27, 2004 at 10:38 am
    Oct 27, 2004 at 2:42 pm
  • I'm hoping that there exists some sample code for interfacing with Oracle XML DB. Ideally, I'd like to see a module like "Oracle::XMLDB" that provides convenience methods to register, update, and ...
    Mark ThomasMark Thomas
    Oct 22, 2004 at 1:30 am
    Oct 22, 2004 at 8:02 am
  • ----- Forwarded message from "Selvam, Shanmugapriya" <shanmugapriya.selvam@hp.com ----- Delivered-To: tim.bunce@pobox.com X-SPF-Guess: pass (seems reasonable for shanmugapriya.selvam@hp.com to mail ...
    Tim BunceTim Bunce
    Oct 20, 2004 at 11:39 pm
    Oct 21, 2004 at 10:14 am
  • Tim, I'm seeing a few typos in the man pages for DBI and family. Would you be interested in patches for that sort of thing? If so, should I send them to you directly or to the list? Joe Bruni
    Joseph BruniJoseph Bruni
    Oct 20, 2004 at 5:47 pm
    Oct 20, 2004 at 11:44 pm
  • I dropped and recreated a table and some indexes while they were being used by a cgi client (big screwup!) Now I am getting the persistent error: Relation <tablename with OID <oid no longer exists I ...
    Alec BrecherAlec Brecher
    Oct 19, 2004 at 7:34 pm
    Oct 19, 2004 at 10:38 pm
  • James, CC'ing dbi-user since this is where you posted first. Basically you are stuffed. I analysed your log and did the same thing in ODBCTest which used to come with MDAC and it fails in the same ...
    Martin J. EvansMartin J. Evans
    Oct 19, 2004 at 4:48 pm
    Oct 19, 2004 at 5:10 pm
  • Hello, I am having some very irritating problems with DBI and DBD::Sybase. I have tried Googling to no avail. What it breaks down to is that a query issued with WinSQL for example, will work fine, ...
    Logan CapaldoLogan Capaldo
    Oct 19, 2004 at 1:38 pm
    Oct 19, 2004 at 3:26 pm
  • Hi ! I have this message chen I tape the line : ppm install DBI.ppd Error : no suitable installation target What is the reason of this message. I didn't find anything on the web. Could you help me ...
    RaphaelRaphael
    Oct 18, 2004 at 4:38 pm
    Oct 18, 2004 at 10:32 pm
  • Hi I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i. I would like to know the amount of CPU usage by Oraperl since we are having CPU usage constraints. I would also like to ...
    Rajarathnam, devarajRajarathnam, devaraj
    Oct 18, 2004 at 8:51 am
    Oct 18, 2004 at 12:55 pm
  • Hello, I'm looking at the Perl DBI O'Reilly book, but it has a publish date of 2000. How much has DBI changed since then? Is the book still a good reference or has it become outdated? Joe
    Joseph BruniJoseph Bruni
    Oct 13, 2004 at 8:59 pm
    Oct 13, 2004 at 10:46 pm
Group Navigation
period‹ prev | Oct 2004 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions90
posts317
users111
websitedbi.perl.org

111 users for October 2004

Tim Bunce: 58 posts Reidy, Ron: 12 posts Jeff Urlwin: 10 posts Joseph Bruni: 8 posts Paul Appleby: 8 posts BAXTER, LINCOLN A: 7 posts Das, Manojit: 7 posts Jonathan Leffler: 7 posts Moosmann, James: 7 posts Peter J. Holzer: 7 posts Henri Asseily: 6 posts Michael Peppler: 6 posts Marco Avvisano: 5 posts Scott T. Hildreth: 5 posts Silvio Wanka: 5 posts Andy Hassall: 4 posts Denesa K Shaw: 4 posts Mahadevan, Arun: 4 posts Ron Savage: 4 posts Stephen Toney: 4 posts
show more
Archives