FAQ

Perl > dbi-users > June 2005

Search Discussions

81 discussions - 225 posts

  • I have a few Oracle tables that have gotten way too big. Normal DELETE/WHERE clauses consume too many resources. I know enough to know that cursors would be more efficient here but I don't know ...
    Steve SapovitsSteve Sapovits
    Jun 23, 2005 at 6:18 am
    Jun 27, 2005 at 6:20 pm
  • Is there a way I can prepare a statement handle for some SQL like insert into some_table values (:a, :b) and then find out what types the database is expecting for the two placeholders? I'm using ...
    Avis, EdAvis, Ed
    Jun 9, 2005 at 1:54 pm
    Jun 16, 2005 at 2:31 pm
  • perl 5.8 DBI, DBD::Proxy 1.21 DBD::Proxy 1.48 linux RedHat 2.4.21 Hello, I am using DBD::Proxy and it looks like impossible to change default values of LongReadLen and LongTruncOk attributes in ...
    Wojciech PietronWojciech Pietron
    Jun 14, 2005 at 3:31 pm
    Jun 16, 2005 at 8:26 am
  • hi i would like to know the detailed architecture and design of dbi. i would like to know how its been written and how it interacts with the drivers etc. i would like to know whats going on ...
    PrashanthPrashanth
    Jun 20, 2005 at 5:24 am
    Jun 20, 2005 at 2:23 pm
  • Does anybody know of any good tools (free or otherwise) for comparing two Oracle schemas? I'd want to be able to compare tables, indices, sequences, etc. to see what one has and another doesn't. In ...
    Steve SapovitsSteve Sapovits
    Jun 16, 2005 at 3:12 pm
    Jun 25, 2005 at 8:51 pm
  • Hi Everyone: I want to connect to an Oracle database and test for the existence of a table. My first thought was to SELECT COUNT(*) FROM TABLE, but DBI catches the ORA-942 error and I don't know how ...
    Vergara, Michael \(TEM\)Vergara, Michael \(TEM\)
    Jun 6, 2005 at 8:11 pm
    Jun 7, 2005 at 1:11 pm
  • Hello all. Is there a simple way to cycle through all open database handles, without needing to know anything about them before-hand? Something like: foreach my $dbh (DBI- ...
    Sam TregarSam Tregar
    Jun 15, 2005 at 6:19 pm
    Jun 20, 2005 at 10:08 am
  • Hi all, I have question about storing hierarchical values in db. I found some methods, pick up the first easiest, but I ahve question about that - have someone coded some methods, or knows some ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    Jun 13, 2005 at 7:18 pm
    Jun 16, 2005 at 2:38 pm
  • I found this page: http://ftp.esoftmatic.com/DBI/ but the DBI.ppd there seems to be an empty HTML page. I've just downloaded ActiveState for Windows and it doesn't come with DBI... help! - erick ...
    Calder, ErickCalder, Erick
    Jun 28, 2005 at 9:22 pm
    Jul 1, 2005 at 11:41 am
  • Thanks for your help. This is Larry Li from Toronto. I am trying to install DBI on AIX 5.2. I am facing the following failure. Step 1: seems it succeeded. root[torts51]/lpp_fs/perl/DBI-1.48: perl ...
    Larry LiLarry Li
    Jun 30, 2005 at 1:46 pm
    Jun 30, 2005 at 4:33 pm
  • When trying to install Test-Simple.ppd, I encountered the following error: C:\WINDOWS\system32 ppm install http://ftp.esoftmatic.com/outgoing/DBI/5.8.4/Test-Simple.ppd Error: Package 'File-Spec' not ...
    Jennifer Romero-higginsJennifer Romero-higgins
    Jun 24, 2005 at 4:48 pm
    Jun 27, 2005 at 3:48 pm
  • I am a Perl newbie. I have interfaced to a MySql database quite a bit with Perl and have had no problem, but I have now been asked to interface with an Oracle database. When I try and install the ...
    Larry LordsLarry Lords
    Jun 20, 2005 at 8:54 pm
    Jun 26, 2005 at 9:52 pm
  • Pete, If you are trying to connect to an Oracle 7 database then you need to use the Oracle 9.0 client. Connecting to Oracle 7 from 9.2 is no longer supported. Any version equal to or less than 9.0.1 ...
    Gold, Samuel (Contractor)Gold, Samuel (Contractor)
    Jun 16, 2005 at 12:38 pm
    Jun 16, 2005 at 3:28 pm
  • David GoodmanDavid Goodman
    Jun 2, 2005 at 1:54 pm
    Jun 2, 2005 at 11:13 pm
  • Hello dbi-users, I have problems with installing DBI-1.48 on Freebsd 5.4 here attached output. I have v5.8.6 built for i386-freebsd-64int Please help me to solve this problem ...
    NickNick
    Jun 29, 2005 at 12:27 pm
    Jul 4, 2005 at 12:15 pm
  • Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the ...
    TherefumpTherefump
    Jun 22, 2005 at 6:40 pm
    Jun 30, 2005 at 10:02 pm
  • I must be doing something wrong or there has to be a better way? I have compiled the dbi module it some how sucks in the path for the oracle libclntsh.so.8.0 and now when ever we move our database to ...
    Morrison DavisMorrison Davis
    Jun 29, 2005 at 10:39 pm
    Jun 30, 2005 at 4:30 pm
  • on Windows: c:\ set HTTP_PROXY=http://your.local.proxy:80 HTH, amonotod -- `\|||/ amonotod@ | sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo____________________________________ ...
    AmonotodAmonotod
    Jun 29, 2005 at 4:46 pm
    Jun 30, 2005 at 1:39 am
  • Google found this for me: http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2004-11/0204.html Tim.
    Tim BunceTim Bunce
    Jun 23, 2005 at 9:19 am
    Jun 24, 2005 at 8:04 pm
  • Hi, Opon attemping a DBD::Oracle install it appears that I must install OCI first to get oci.h ... But if I attempt to install OCI first it baulks that it can't find Oracle.pm Any suggestions? Here ...
    McLean, Emmett (HQP)McLean, Emmett (HQP)
    Jun 14, 2005 at 11:58 pm
    Jun 15, 2005 at 2:09 pm
  • HI I am trying to install DBI and DBD modules on Solaris 10 and getting following error. Please suggest is there any solution for this problem. Perl.xsc && mv Perl.xsc Perl.c cc -c ...
    Shailesh MaliShailesh Mali
    Jun 13, 2005 at 12:39 pm
    Jun 14, 2005 at 4:01 pm
  • Hello, Im involved in a project to setup a tamino -XML-Database for the web. My problem is now, that I cannot find any Tamino-Driver for DBI. Is there any workarround or solution I can use for this? ...
    Christian StalpChristian Stalp
    Jun 10, 2005 at 3:13 pm
    Jun 11, 2005 at 10:40 pm
  • How does a script handle when null values are returned from a stored procedure? I checked for Null values in a individual string, but it seemed not to make it to my if statement. Thanks in advance. ...
    Denesa K ShawDenesa K Shaw
    Jun 9, 2005 at 1:23 pm
    Jun 9, 2005 at 7:20 pm
  • After yesterday's dummy question, I'm afraid to reveal more of my ignorance, but here goes. I think that this code: $SQLstmt = q{ alter user :DBUser identified by blarg }; print "1 Executing ...
    Vergara, Michael \(TEM\)Vergara, Michael \(TEM\)
    Jun 7, 2005 at 3:35 pm
    Jun 7, 2005 at 7:21 pm
  • [added dbi-users in case there are more people who can help there] However, since I'm not a MAC expert (although, I scrounged an old iMac which is running OS/X now). Can you tell which version of ...
    Jeff UrlwinJeff Urlwin
    Jun 6, 2005 at 3:28 pm
    Jun 6, 2005 at 11:12 pm
  • Hi, I'm trying to debug an install for my DBD::ODBC module, and since this is my first experiment with the DBI, I have a question on format/syntax. But first, here's some background info that may/not ...
    Smith, Sharon Michelle (OSLO)Smith, Sharon Michelle (OSLO)
    Jun 1, 2005 at 9:39 pm
    Jun 2, 2005 at 10:59 am
  • Hi Tim, I am getting an error ora-12660 while trying to connect to the database using DBI/DBD. I am using the command "dbi:Oracle:host=xyz;sid=abc" in order to connect to database abc. This error ...
    PuneetPuneet
    Jun 1, 2005 at 9:32 pm
    Jun 1, 2005 at 11:02 pm
  • Hi Six months ago, I was asked to install Oracle 9.2.0.6 client and perl with DBI/DBD. It was ever so easy! Two days, I was asked to repeat the exercise again on another server. Using the same Perl, ...
    Simon WindsorSimon Windsor
    Jun 29, 2005 at 5:11 pm
    Jun 30, 2005 at 4:50 am
  • Morrison DavisMorrison Davis
    Jun 29, 2005 at 9:42 pm
    Jun 29, 2005 at 10:05 pm
  • Does dbi provide asynchronous calls? If not, what perl module is there that supports asynchronous sql query calls to the database - meaning, I don't have to wait for the call to return. I am using ...
    Rajeev GuptaRajeev Gupta
    Jun 28, 2005 at 5:39 pm
    Jun 29, 2005 at 7:08 pm
  • Trying to install DBD::Oracle on a fresh install of perl 5.8.7 (installed DBI through CPAN first) on a solaris box. Make seems to go well, but make test bombs horribly. Running individual tests (perl ...
    Gale, DavidGale, David
    Jun 24, 2005 at 8:02 pm
    Jun 25, 2005 at 4:19 pm
  • Google is your friend: http://www.google.com/search?q=undefined+symbol%3A+ociepgoe&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official From there ...
    Reidy, RonReidy, Ron
    Jun 24, 2005 at 8:08 pm
    Jun 24, 2005 at 8:09 pm
  • ----- Forwarded message from Regis Biassala <Regis.Biassala@version1.com ----- From: "Regis Biassala" <Regis.Biassala@version1.com To: <Tim.Bunce@pobox.com Subject: Perl DBD with Oracle 10g Date: ...
    Tim BunceTim Bunce
    Jun 24, 2005 at 12:06 pm
    Jun 24, 2005 at 12:06 pm
  • Hi Folks Sorry if you've seen this, but I did not receive a copy. (This is under WinXP, with a DSN pointing to an MS Access db). Is there an ODBC function call, or anything, which will distinguish ...
    Ron SavageRon Savage
    Jun 23, 2005 at 8:19 am
    Jun 23, 2005 at 8:32 am
  • Hi Conrad, I have a doubt regarding the usage of export.pm. The doubt is I have an xx.pl file which uses yy.pm (use yy;) Now this yy.pm has all subroutines and it tooo uses some other packages...... ...
    Vamsi_DoddapaneniVamsi_Doddapaneni
    Jun 22, 2005 at 12:39 pm
    Jun 23, 2005 at 2:01 am
  • Hi, I am having problems running DBI-1.48 using DBD-DB2-0.78. The issue is that when I run a "make test" prior to running a "make install" for the compilation of the Perl DBD-DB2-0.78 module on AIX ...
    Chris L GrassiChris L Grassi
    Jun 22, 2005 at 1:38 am
    Jun 23, 2005 at 1:46 am
  • Thanks for all the great help! When I try and connect to the Oracle server I get the following "Unable to Locate Component" error box: This application has failed to start because OCI.dll was not ...
    Larry LordsLarry Lords
    Jun 22, 2005 at 5:08 pm
    Jun 22, 2005 at 5:18 pm
  • Just a quick note you might want to add to the README.clients file for DBD::Oracle ... To build DBD::Oracle against a minimally built/configured instalation of Oracle 10g 10.1, download and unzip the ...
    David CantrellDavid Cantrell
    Jun 22, 2005 at 10:44 am
    Jun 22, 2005 at 12:57 pm
  • Hi, i want to use perl DBI for "Using XML and Relational Databases with Perl". I am using a package called apachefriends/xampp, where perl comes with that package,which do not have the DBI package. ...
    BabuBabu
    Jun 22, 2005 at 8:52 am
    Jun 22, 2005 at 9:51 am
  • I spent a good deal of time to get the following working after searching through Google, so I thought maybe there's someone else that could benefit from this. The function that is called takes a ...
    PiaPia
    Jun 21, 2005 at 10:30 pm
    Jun 21, 2005 at 10:38 pm
  • The following code works just fine: $sth = $dbh- prepare(qq(select count(*) from discounts where min_value < ?)); $sth- bind_param( 1, 5, SQL_INTEGER); $sth- execute(); The actual query my ...
    Keith JacksonKeith Jackson
    Jun 21, 2005 at 3:21 pm
    Jun 21, 2005 at 5:39 pm
  • I'm not sure if there is a reason why this hasn't been done already but we've been having problems integrating Apache::DBI caching and DBD::Proxy to DBD::Pg without the ping functionality. # diff ...
    Campbell, GeorgeCampbell, George
    Jun 20, 2005 at 6:15 pm
    Jun 21, 2005 at 12:16 am
  • Hi, (sorry for fairly lengthy post) I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, and MySQL. However, after upgrading to Fedora Core 4, I am no longer able to connect to ...
    Jonas AnderssonJonas Andersson
    Jun 15, 2005 at 11:14 am
    Jun 17, 2005 at 10:13 am
  • Aloha. Have just inherited a failed web app. It originally was running on unix. Then got ported to NT. Then ported to Win2k. Client network admins recently updated the server and the web application ...
    Hope PeterHope Peter
    Jun 16, 2005 at 2:40 am
    Jun 17, 2005 at 4:18 am
  • Hi, I am using Oraperl pack for my development. I get the following error at the line where I use Oraperl ( use Oraperl). Unknown error Compilation failed in require at ...
    Ashish JainAshish Jain
    Jun 16, 2005 at 9:55 am
    Jun 16, 2005 at 2:22 pm
  • Hi, I am having the following issue in my project. Basically we have a perl based application in which we pass value from one page to another using URL. In any page we fetch the value of a particular ...
    Arijit BanikArijit Banik
    Jun 9, 2005 at 11:58 am
    Jun 9, 2005 at 6:45 pm
  • Hi, for the last 2 days I've been trying to get a simple connection to a Sybase 11x server running on Linux. Here is the script: <stript #!/usr/bin/perl -w use strict; use DBI; my $dbh = DBI- ...
    David FilionDavid Filion
    Jun 8, 2005 at 3:10 pm
    Jun 9, 2005 at 6:24 pm
  • You've not quoted version numbers for: oracle client, oracle server, DBI, or DBD::Oracle. Nor URLs to the old thread you refer to. Some old DBD::Oracle versions did have a problem setting the row ...
    Tim BunceTim Bunce
    Jun 7, 2005 at 9:07 am
    Jun 8, 2005 at 10:12 am
  • No, None that I can think of. $ODBCHOME/lib/*iodbc* libraries were there and $ODBCHOME/lib/*odbc* libraries (what I think unixodbc installs) were not. Yet Makefile.PL was pretty sure that unixodbc ...
    Christopher PryceChristopher Pryce
    Jun 7, 2005 at 3:20 am
    Jun 7, 2005 at 2:20 pm
  • Hello! I'm trying to compile DBD-Informix-2005-01 ( as user root )with DBI 1.48 at HP-UX 11.00 with perl 5.8.6. I have a problem with loading shared library. The requested shared library is at the ...
    Piotr PoloczekPiotr Poloczek
    Jun 6, 2005 at 4:55 pm
    Jun 7, 2005 at 12:43 am
Jun 2005
12
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions81
posts225
users99
websitedbi.perl.org

99 users for June 2005

Tim Bunce: 16 posts Michael A Chase: 14 posts Reidy, Ron: 13 posts Jonathan Leffler: 7 posts Martin J. Evans: 7 posts Jeff Urlwin: 6 posts Job Miller: 6 posts Steve Sapovits: 5 posts Wojciech Pietron: 5 posts Avis, Ed: 4 posts Daniel Kasak: 4 posts Larry Li: 4 posts Morrison Davis: 4 posts Ron Savage: 4 posts Sam Tregar: 4 posts Scott T. Hildreth: 4 posts Calder, Erick: 3 posts Christopher Pryce: 3 posts Hope Peter: 3 posts Jared Still: 3 posts
show more
Archives