FAQ

Perl > dbi-users > May 2005

Search Discussions

74 discussions - 263 posts

  • Hi All, I am in a Perl based project, where we fire a query which returns 20K records. In the perl side, we use the following snippet to get the query result to an array. while ( @each_record = ...
    DivyaDivya
    May 12, 2005 at 11:58 am
    May 21, 2005 at 1:34 am
  • A question from a DBA here: Does DBD::Oracle use Oracle's "array interface" to interface to Oracle? -- Steve Sapovits steves06@comcast.net
    Steve SapovitsSteve Sapovits
    May 3, 2005 at 7:12 pm
    May 5, 2005 at 9:04 am
  • Hello dbi-users, I'm relatively new to Perl DBI so bear with me as this might be very simple for the gurus. I would like to use the results of a query as an input to another query's WHERE ... IN ...
    RicarddRicardd
    May 25, 2005 at 6:39 pm
    May 26, 2005 at 9:18 pm
  • Hi all, Thanks for your help. I am facing a new problem. Here is the code part: foreach $name(`ls $opt_i/*.xml`){ chomp; push @f, $name; print "pushing elements=$name\n"; } $n=@f; Now in the ...
    Vamsi_DoddapaneniVamsi_Doddapaneni
    May 9, 2005 at 10:17 am
    May 24, 2005 at 1:23 pm
  • I have compiled DBD-ODBC-1.13 on RedHat Enterprise Linux 4. Failed 2/9 test scripts, 77.78% okay. 6/137 subtests failed, 95.62% okay. Good enough for me so I installed it. I am using unixODBC-2.2.9-. ...
    Stephen MoreStephen More
    May 16, 2005 at 9:25 pm
    May 19, 2005 at 1:11 pm
  • Hi all, I'm making script, and I'd like add column, if column not exist. My DBS is MySQL, and I didn't find direct SQL command for this. Is there some workaround for this ? thanks.
    Ing. Branislav GerzoIng. Branislav Gerzo
    May 12, 2005 at 6:39 am
    May 13, 2005 at 11:20 pm
  • Has anyone ever seen this message? I have a valid handle - all of my database commands work. The command is simply $dbh- disconnect(); What level should I use if I turn on tracing? TIA -- Matthew O. ...
    Matthew PersicoMatthew Persico
    May 20, 2005 at 2:08 pm
    May 25, 2005 at 1:57 pm
  • My ignorance is showing. : ) I am pulling data out of Oracle and putting it into an Excel spreadsheet. Using this: while ( $row = $sth- fetchrow_arrayref ) { # this is a fast and simple way to deal ...
    RobertRobert
    May 9, 2005 at 7:45 pm
    May 10, 2005 at 3:38 pm
  • We installed DBI , DBD::Oarcle and 9.2 Oracle client. And this is run , we get this error. ./oracletest.pl install_driver(Oracle) failed: Can't load ...
    Daniel TekluDaniel Teklu
    May 12, 2005 at 3:02 pm
    Jun 7, 2005 at 3:22 pm
  • I am trying to set the LongReadLen value of $dbh dynamically to select a CLOB, using: $dbh- {LongReadLen} = $dbh- selectrow_array(qq{ SELECT MAX(mc.mc_long_description) FROM dmg.maint_codes mc }); ...
    Tantalo, Christopher GTantalo, Christopher G
    May 26, 2005 at 1:58 pm
    May 29, 2005 at 6:08 am
  • As another episode of the DBD::Oracle on MacOSX quest, I tried the Oracle 10g Instant Client for 10.3 on Panther, using DBD::Oracle 1.16 (the latest I believe). First the good news (and it's ...
    Hilmar LappHilmar Lapp
    May 13, 2005 at 10:53 pm
    May 17, 2005 at 9:26 am
  • Hi guys, I am trying to resolve a horrible error I am getting, and I really don't know where to start! I have created a Database link in Oracle and created a view to one of the tables in it. Now when ...
    Hawkes, RichardHawkes, Richard
    May 3, 2005 at 2:37 pm
    May 4, 2005 at 1:06 pm
  • I am trying to load gcc 3.3.2 in order to load and compile perl 5.8 and finally load DBI. I am using UNIX OS with Solaris 8 on a SunBlade 2000. This is what I did: # cd /local/icab11/gcc_load # ls ...
    IthierIthier
    May 19, 2005 at 4:45 pm
    May 19, 2005 at 8:42 pm
  • Hi, I'm having a problem with DBD::Informix when using it's functions via a 'goto &$sub' mechanism. My program is a CGI script in perl, which provides web-access to a database in Informix. The ...
    Konstantin SolodovnikovKonstantin Solodovnikov
    May 17, 2005 at 9:36 pm
    May 18, 2005 at 3:14 pm
  • Hello, I have a pretty old version of DBI on a production server. I'd like to upgrade (partly so that the version up there will be closer to the development environment). I've been looking around for ...
    April BlumenstielApril Blumenstiel
    May 17, 2005 at 7:00 pm
    May 18, 2005 at 1:23 pm
  • Our web server is running Apache 2.0.48 with mod_perl 1.99_12 on a Sun machine running Solaris 9. We are running perl 5.8.1, DBI 1.39 and DBD-Oracle 1.16. We are trying to connect from our web server ...
    Malka CymbalistaMalka Cymbalista
    May 25, 2005 at 11:47 am
    May 30, 2005 at 8:32 am
  • Hi, I'm running into a problem trying to build DBD::Informix on a Redhat ES3 host, with a database on a Solaris 9 host. Client: RedHat ES3, 2.4.21-15.0.4.ELsmp, perl v5.8.0, Informix ...
    Bruce LysikBruce Lysik
    May 10, 2005 at 12:24 am
    May 28, 2005 at 2:16 am
  • Example: (Using DBD::SQLite) $ref_rsch = $dbh- selectall_hashref(' SELECT * FROM rsch ORDER BY Idx ', 'Idx'); while (my ($k, $v) = each(%$ref_rsch)){ while (my ($k, $v) = each(%$v)){ print "$k = ...
    Yu WangYu Wang
    May 27, 2005 at 5:53 am
    May 27, 2005 at 8:05 pm
  • Jeff, Thanks for the response. I thought the same thing: Maybe it is failing because the table does not exist, so I created it using the same username and password. It still fails. I am trying to ...
    Mark VaughanMark Vaughan
    May 10, 2005 at 4:01 pm
    May 13, 2005 at 2:34 am
  • Hi, How do get the date to be in the format like this? mm/dd/yyyy hh24:mi:ss When I run this code It prints: START TIME: 01-JAN-05, END TIME: 02-JAN-05 Thanks in advance! Here is what I have: my $sql ...
    Denesa K ShawDenesa K Shaw
    May 11, 2005 at 12:15 pm
    May 11, 2005 at 2:57 pm
  • I am running a postgresql database and am finding that DBI is returning the wrong data type for the postgresql DATE type. Here is some example code: ==================================== <snip - ...
    Collin PetersCollin Peters
    May 2, 2005 at 9:29 pm
    May 5, 2005 at 3:46 pm
  • I am using gcc for my c-compiler. Any help would be appreciated. The output of perl -V and perl Makefile.PL and make are below. If you need anymore information just email me. The output is also in ...
    Evans, Drexter B (Drex)Evans, Drexter B (Drex)
    May 31, 2005 at 7:36 pm
    Jun 1, 2005 at 4:34 pm
  • Hi, I'm migrating a perl application in postgres to Oracle. Here, the data is being retrieved as below. while ($row = $sth- fetchrow_hashref()) { push (@list,$row); } It looks like fetchrow_hashref() ...
    PerlDiscuss - Perl Newsgroups andPerlDiscuss - Perl Newsgroups and
    May 31, 2005 at 2:35 pm
    May 31, 2005 at 3:23 pm
  • Has anyone used DBI in an Oracle 9i RAC configuration on Linux? If so, were there any issues moving to RAC? -- Steve Sapovits steves06@comcast.net
    Steve SapovitsSteve Sapovits
    May 26, 2005 at 4:10 pm
    May 26, 2005 at 4:19 pm
  • Dear Friend, I am shnathi Nagarajan working as a computer operator in Bioinformatics centre, Pondicherry University, India. Presently I am trying to connect perl and mysql. I have downloaded ...
    Shanthi nagarajanShanthi nagarajan
    May 24, 2005 at 1:40 pm
    May 25, 2005 at 2:38 am
  • HI, I'd like to build a secure connection to PostgreSQL, but I can't imagine how to do it, its the same like building a connection with the insecure protocol? How does that work? could someone make ...
    Xaver bitonXaver biton
    May 20, 2005 at 2:48 pm
    May 20, 2005 at 4:54 pm
  • Hi there I have followed all the instructions in the README files for the DBD::Oracle package but get strange errors when running the "make" command. Output: MAKE Version 5.2 Copyright (c) 1987, 1998 ...
    Rudolf NiehausRudolf Niehaus
    May 20, 2005 at 2:57 pm
    May 20, 2005 at 3:21 pm
  • Hi, In our application, we generate excel which is more than 150MB of size. Currently when a user clicks on Excel download link that we have provided in the application, As of now we are able to ...
    DivyaDivya
    May 18, 2005 at 8:12 am
    May 18, 2005 at 3:35 pm
  • On Windows XP Pro using Perl 5.8.6, DBI v1.43 and DBD::Oracle v1.06: I'm encountering a strange fetchrow_hashref error that I can't find any information about, either in the DBI or DBD::Oracle ...
    Michael StyerMichael Styer
    May 16, 2005 at 2:58 pm
    May 16, 2005 at 8:50 pm
  • Hi All, Can any body help on how we pass by reference n the following context: Sub callingfunc { My $tempvar; $tempvar- {'name'} = "ABCD"; Calledfunc($tempvar); } # I need to pass the $ tempVal ; ...
    DivyaDivya
    May 16, 2005 at 4:32 pm
    May 16, 2005 at 6:50 pm
  • All, I am receiving numerous errors when running the 'make check' for DBD::Sybase. My environment: Solaris 2.8 Perl 5.6.1 Freetds 0.63 Here is the output from 'make check': Running make test ...
    Mark VaughanMark Vaughan
    May 13, 2005 at 1:25 pm
    May 15, 2005 at 10:04 pm
  • All, I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl, and DBI installed and working. I'd like to be able to execute Oracle stored procedures. Is anyone doing this without the ...
    Kevin MooreKevin Moore
    May 10, 2005 at 4:40 am
    May 10, 2005 at 1:49 pm
  • If I make a user-defined type synonym, should the name of this synonym appear as TYPE_NAME in the type_info() output or should TYPE_NAME give the original SQL type the synonym is defined as? ...
    Avis, EdAvis, Ed
    May 6, 2005 at 4:37 pm
    May 7, 2005 at 6:09 pm
  • Hi Guys, When i do select quiery and then try to get count of rows like this in perl script from Oracle database and Informix: $rowCnt = $sth- rows; above line is being executed after the $sth- ...
    Rabish KumarRabish Kumar
    May 5, 2005 at 3:52 pm
    May 5, 2005 at 7:56 pm
  • My ultimate goal is to load DBI to interface Perl with Sybase. I am using Solaris 9 Operating system on a SUN Fire 880 Server. The following are the step I followed to load the DBI. ...
    IthierIthier
    May 3, 2005 at 6:38 pm
    May 4, 2005 at 1:39 pm
  • Hello, I have encountered a problem when I tried to install a DBI perl extension of binary. The platform is a Linux EL 3 ES 2.4.21-27.0.4.ELsmp. I am using ActivePerl 5.8.6.811. The installation was ...
    Jin ChiuJin Chiu
    May 26, 2005 at 10:03 pm
    May 27, 2005 at 10:59 am
  • I am sorry if this is covered somewhere that I have been unable to find it. I have not been able to connect to the FAQ at http://dev.isystek.com/dbi/fom.cgi. The only faq's I have found on-line are ...
    KnodelKnodel
    May 26, 2005 at 8:36 pm
    May 26, 2005 at 9:16 pm
  • Hi all I have a problem with java application. My shell script uses some jar files and calls a class I have set up the DBAccessor.properties with driver=COM.ibm.db2.jdbc.app.DB2Driver # specify ...
    Vamsi_DoddapaneniVamsi_Doddapaneni
    May 26, 2005 at 3:08 pm
    May 26, 2005 at 5:09 pm
  • Had to apply this patch to get DBD::Oracle to work on my RedHat FC3 system which installed the include files over in /usr/include/oracle/version-#/... Thanks much for the package. *** Makefile.PL.ORG ...
    Gray PerlGray Perl
    May 25, 2005 at 11:25 pm
    May 26, 2005 at 9:23 am
  • Hi Cees I'm sure happy to have used it in production settings. -- Cheers Ron Savage, ron@savage.net.au on 26/05/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an ...
    Ron SavageRon Savage
    May 25, 2005 at 10:43 pm
    May 25, 2005 at 10:46 pm
  • I use DBD::SQLite as my database and I am wondering if there is any function that checks the existence of a table? Or, how to list all the tables in a SQLite database using DBI? Thanks a lot!
    Yu WangYu Wang
    May 22, 2005 at 5:42 pm
    May 22, 2005 at 7:00 pm
  • Dear all, I am attempting to package a common Perl v5.8.6 + DBI v1.48 + DBD::Oracle v1.16 on Solaris 8+ for use at my site. The DBD::Oracle module has been compiled against Oracle 10g client and ...
    David BartlettDavid Bartlett
    May 20, 2005 at 2:17 pm
    May 20, 2005 at 10:19 pm
  • ----- Forwarded message from "Bepristis, Brian" <bbeprist@ci.grand-rapids.mi.us ----- From: "Bepristis, Brian" <bbeprist@ci.grand-rapids.mi.us To: Tim.Bunce@pobox.com Subject: DBI Date: Thu, 19 May ...
    Tim BunceTim Bunce
    May 19, 2005 at 10:10 pm
    May 20, 2005 at 12:00 am
  • How to unsubscribe this mailing list? Any Help? -----Original Message----- From: Adriano Ferreira Sent: Wednesday, May 18, 2005 6:23 AM To: dbi-users@perl.org Subject: Re: upgrading dbi I think April ...
    Sudhahar ThiagarajanSudhahar Thiagarajan
    May 19, 2005 at 5:28 pm
    May 19, 2005 at 6:37 pm
  • Tim, I'm curious: have you ever experimented with nonblocking OCI in your DBD::Oracle driver? I've been using Perl Object Environment (POE) for some time now, and some projects I'd like to start ...
    Eric RybskiEric Rybski
    May 16, 2005 at 11:40 pm
    May 17, 2005 at 11:53 pm
  • Hi, I am using the DBI to extract some data from the underlying Informix Database. Even after doing the following when I am printing the value for $start_date, it is in the format 'dd/mm/yyyy' ...
    Nitin NairNitin Nair
    May 17, 2005 at 5:58 am
    May 17, 2005 at 8:01 am
  • Hello, I'd like to do something like this: $sth- prepare(...) $sth- execute(...) while (my $hr = $sth- fetchrow_hashref) { my $oses = get_os( $hr- {id} ); ... } Function get_os() prepare, execute and ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    May 16, 2005 at 1:22 pm
    May 16, 2005 at 5:55 pm
  • Hello all, exist a better error description for DBI errors? I have quite complex datastructure, I'm saving it to DB, using ODBC and MS SQL 2000. I get only: DBD::ODBC::st execute failed: ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    May 16, 2005 at 6:58 am
    May 16, 2005 at 9:57 am
  • How do I pass the value of the variable "$FILE_NM" returned in the subroutine "get_file" to the subroutine "Update_T_Received"? I'm needing this value to for my update statement. Normally I can ...
    Denesa K ShawDenesa K Shaw
    May 13, 2005 at 6:01 pm
    May 14, 2005 at 2:06 pm
  • Hello! I want to show a table of a MySQL Database in the internet using HTML Templates. I read HTML Template loops can best handle hashes of arrays. How can I create this structure out of the ...
    Kemmann, UrsKemmann, Urs
    May 11, 2005 at 3:22 pm
    May 11, 2005 at 9:15 pm
May 2005
12
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions74
posts263
users111
websitedbi.perl.org

111 users for May 2005

Tim Bunce: 21 posts Jonathan Leffler: 12 posts Michael A Chase: 11 posts Reidy, Ron: 9 posts Ing. Branislav Gerzo: 7 posts Jared Still: 7 posts Job Miller: 7 posts Mark Vaughan: 7 posts Steve Sapovits: 7 posts Ian Harisay: 6 posts Matthew Persico: 6 posts Michael Peppler: 5 posts Stephen More: 5 posts Steven Lembark: 5 posts Jeffrey Seger: 4 posts Divya: 4 posts Jeff Urlwin: 4 posts Martin J. Evans: 4 posts Yu Wang: 4 posts Collin Peters: 3 posts
show more
Archives