FAQ

Perl > dbi-users > November 2002

Search Discussions

160 discussions - 528 posts

  • I have a simple query using a LIKE in the statement and I just can get it to return any data. I know it works because i can do it in sqlplus and get data returned. I have tried everything to try to ...
    Kipp, JamesKipp, James
    Nov 14, 2002 at 1:46 pm
    Nov 19, 2002 at 9:17 pm
  • Hi all, I have a strange problem. I have a script that runs a series of queries & writes the results to files. The core part of this script looks like: for (my $i = 1; $i < 7; $i++) { process(635, ...
    Paul BoutrosPaul Boutros
    Nov 18, 2002 at 5:44 pm
    Nov 26, 2002 at 3:09 am
  • Hi, I am not getting any output using the below code. #!/usr/bin/perl use strict; use warnings; use DBI; -- connecting to database (okay with this, it works) -- my (@centers, $stmt, $sth, $row); ...
    Ramon HildrethRamon Hildreth
    Nov 27, 2002 at 1:01 pm
    Nov 27, 2002 at 6:00 pm
  • As I sit here contemplating my woes over a fresh Martini, I thought that I might post my problem in the hopes that those PERL guru's from on high would bestow a small perl (pun intended) of wisdom ...
    Dana LucentDana Lucent
    Nov 13, 2002 at 12:35 am
    Nov 17, 2002 at 10:31 pm
  • Be gentle. ----- Forwarded message from "[email protected] via RT" <[email protected] ----- Date: 13 Nov 2002 15:43:42 -0000 To: "AdminCc of perl Ticket #18355": ; From: ...
    Tim BunceTim Bunce
    Nov 13, 2002 at 5:14 pm
    Nov 17, 2002 at 10:27 pm
  • ----- Forwarded message from Josh Wilmes <[email protected] ----- Delivered-To: [email protected] To: T[email protected] Subject: DBD::Oracle / alarm() problem From: Josh Wilmes <[email protected] ...
    Tim BunceTim Bunce
    Nov 21, 2002 at 9:18 am
    Dec 4, 2002 at 11:13 am
  • Consider the following script: #!/usr/bin/perl use strict; use warnings; use DBI; my $dbh = DBI- connect('dbi:mysql:music', 'user', 'pass'); my $insert = $dbh- prepare_cached(qq{ INSERT INTO user ...
    Tony BowdenTony Bowden
    Nov 25, 2002 at 3:16 pm
    Dec 1, 2002 at 8:35 pm
  • That's a message for dbi-users. I've directed followups there. Tim.
    Tim BunceTim Bunce
    Nov 21, 2002 at 5:01 pm
    Nov 29, 2002 at 8:13 pm
  • Is there a way to get a list of all table names in specific database using DBI:mysql in Perl? I can get the list of databases using: @databases = DBI- data_sources("mysql"); and the list of fields in ...
    Chris RogersChris Rogers
    Nov 26, 2002 at 2:47 pm
    Nov 28, 2002 at 7:24 am
  • I am setting in place an Apache Web server and I want to get access to a remote Oracle 8 database. Here are the step I did 1) I set up Linux RedHat 7.3 (Kernel 2.4.18-3 2) I updated OS through RHN ...
    Armand BrissonArmand Brisson
    Nov 4, 2002 at 7:24 am
    Nov 7, 2002 at 7:47 am
  • Hi, I'm having a problem inserting a row into my database with a CLOB column. My database version is Oracle 8.1.7. I can get it to work as long as my CLOB contains < 4948 bytes. However, if it is = ...
    Wysocki, James (J.D.)Wysocki, James (J.D.)
    Nov 13, 2002 at 3:16 pm
    Nov 13, 2002 at 11:25 pm
  • I'm having some problems with DBD::ADO and inserting/updating records. Specifically, after carrying out one of these operations, the number of records inserted is not returned, which means that it is ...
    OliverOliver
    Nov 7, 2002 at 4:31 pm
    Nov 28, 2002 at 9:59 am
  • Hello, I have a function in our Oracle database (a function, not a procedure). I would like to execute this function from my perl script using DBI. I wrote something like this : my $sql=qq[ BEGIN ...
    NYIMI Jose (BMB)NYIMI Jose (BMB)
    Nov 18, 2002 at 2:33 pm
    Nov 18, 2002 at 8:16 pm
  • Can anyone point me to the answer? I want to use an arbitrary group in the group by statement. I can group by year but want to change the calendar year to another unit of measure such as quarter. ...
    Fong, AnnaFong, Anna
    Nov 14, 2002 at 8:00 pm
    Nov 14, 2002 at 9:46 pm
  • I do a lot of select in many statement and fetch the result on a array as needed. But now one of my staement is a "select count() from ...". How can I get the value of this statement?
    Stephane LegaultStephane Legault
    Nov 12, 2002 at 5:58 pm
    Nov 12, 2002 at 10:39 pm
  • Hello, I use Perl 5.6.0, DBI 1.30 and DBD-Oracle 1.12. While checking the performance, my Oracle-Tools discovered, that the Database does two prepares for every execute. My Perl-Code looks like this: ...
    Henning MeyerHenning Meyer
    Nov 28, 2002 at 10:37 am
    Dec 2, 2002 at 9:45 am
  • I have an application which makes extensive use of hash references when fetching and manipulating query results. As the underlying database is PostgreSQL, the returned hash keys are lower case ...
    Ian BarwickIan Barwick
    Nov 30, 2002 at 8:53 pm
    Nov 30, 2002 at 11:45 pm
  • How can I execute a SQL Server stored proc from my Perl script? The Cheeta book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape sequence: {call procedure1_name} Fine. But what's ...
    Brien PirkleBrien Pirkle
    Nov 28, 2002 at 10:00 am
    Nov 29, 2002 at 10:28 am
  • I don't know if this is the right place to post DBI/DBD bug reports. If there is a better place please let me know. The small program below results in an error that reads: The instruction at ...
    Ronald SchmidtRonald Schmidt
    Nov 18, 2002 at 4:16 pm
    Nov 19, 2002 at 10:50 pm
  • Looked at Q&A for databases at perl.org, been through the Cheetah book (several times) and can't seem to find an archive of this list so I'm down to asking for help what is probably a FAQ. But I hope ...
    Roderick A. AndersonRoderick A. Anderson
    Nov 18, 2002 at 9:23 pm
    Nov 18, 2002 at 11:39 pm
  • Hello I want to use crond for launching a script every hour. in a shell, my script is oukay but when i put it incrond i've got this mail (root) <<< From: daemon To: root Open Client Message: Message ...
    Julien PringuayJulien Pringuay
    Nov 14, 2002 at 2:01 pm
    Nov 14, 2002 at 4:31 pm
  • Folks, I am running into a problem here: My script is running on: Solaris SunOS 5.8 Generic_108528-15 sun4u sparc SUNW,Ultra-Enterprise Perl 5.6.1 DBI 1.18 DBD::Oracle 1.07 It gives the following ...
    Jibo JohnJibo John
    Nov 13, 2002 at 11:35 pm
    Nov 14, 2002 at 2:46 pm
  • Can I connect to a remote MS Access database with dbi? If so what's the port number? dbi:ODBC:dbName:hostname=host:port=????' Thanks! nick marsh [email protected]
    Nicholas MarshNicholas Marsh
    Nov 13, 2002 at 2:06 am
    Nov 13, 2002 at 5:09 pm
  • I want to run a query that will perform a phrase search on all fields in the table. I thought that it seemed really logical to write the statement like: my $dbh = DBI- ...
    Brad SmithBrad Smith
    Nov 5, 2002 at 1:56 pm
    Nov 8, 2002 at 2:14 pm
  • Hi, I'm new to this list, so hello everyone, and sorry if I ask already answered questions. My pb is that I have an oracle database with datas encoded in iso-latin15 and when I use DBI::Oracle to ...
    DamsDams
    Nov 5, 2002 at 4:11 pm
    Nov 6, 2002 at 10:04 pm
  • Paul ChanPaul Chan
    Nov 26, 2002 at 4:45 am
    Nov 26, 2002 at 10:44 pm
  • I have a Perl script acting as a CGI processor with many values being passed, and the values can possibly be empty. This seems to cause problems. I have a prepare statement with 19 columns with 17 ...
    Daniel OlsonDaniel Olson
    Nov 21, 2002 at 11:13 pm
    Nov 23, 2002 at 10:32 pm
  • Hi, I'm trying to build DBD::Oracle 1.12 on the latest cygwin, and perl 5.8 - without much success. I have Oracle 9.2 installed on the XP side of my machine, and have verified it is functional. I can ...
    Steve BaldwinSteve Baldwin
    Nov 18, 2002 at 9:26 am
    Nov 18, 2002 at 8:33 pm
  • Is there a way to easily lock a table ? so that no updates can happen untill my script is done? I am using DBD::Oracle? < < Proverbs 3:5 "Trust in the Lord with all your heart and lean not on your ...
    John GedeonJohn Gedeon
    Nov 11, 2002 at 8:06 pm
    Nov 13, 2002 at 3:14 pm
  • James - check this out. http://xmlproj.com/fom-serve/cache/122.html -----Original Message----- From: James Shane Sent: Friday, November 08, 2002 1:24 PM To: [email protected] Subject: DBI Oracle 9i ...
    Rose, BillRose, Bill
    Nov 8, 2002 at 6:40 pm
    Nov 9, 2002 at 2:11 pm
  • When I need to have a "use DBD::Oracle qw(:ora_types);" in my program, and I am running from cron, I get a message like: Can't load '<long path /auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:' at ...
    Fox, MichaelFox, Michael
    Nov 5, 2002 at 11:44 pm
    Nov 6, 2002 at 10:42 pm
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.31.tar.gz size: 276605 bytes md5: cd6d40e37ac2cad6db53e7dfbb1baf1c =head1 Changes in DBI 1.31, 29th November 2002 The fetchall_arrayref method, when called with ...
    Tim BunceTim Bunce
    Nov 30, 2002 at 1:04 am
    Dec 1, 2002 at 11:11 pm
  • Hi there, this is kinda OT, since i fear it's more of a mysql than dbi issue, but here goes... the thing is that i have this long-running perlTk app. if i forcefully bring my database-servre down ...
    Moritz von SchweinitzMoritz von Schweinitz
    Nov 26, 2002 at 9:55 pm
    Nov 29, 2002 at 10:11 am
  • Can someone please tell me if the RowCacheSize needs to be set before calling 'prepare' or before calling 'execute' if I want it to be effective for a SELECT statement. I'm using Oracle, so I know it ...
    Steve BaldwinSteve Baldwin
    Nov 28, 2002 at 12:29 am
    Nov 28, 2002 at 1:11 am
  • Please forgive what I'm sure is a really stupid question - but the fact is I've never been in a situation where I didn't have root access to install my modules. I need to get DBI on a web server ...
    Chris FaustChris Faust
    Nov 22, 2002 at 10:27 pm
    Nov 23, 2002 at 4:09 am
  • Hope this isn't too simple a question.....but I can't find an example in my "Programming the Perl DBI"...platform is NT, ActivePerl 633...database is SQLServer2000, connection is DBI:ODBC When I ...
    Brien PirkleBrien Pirkle
    Nov 19, 2002 at 9:55 am
    Nov 20, 2002 at 10:19 am
  • say, use strict; use DBI; $CommandString = "exp $username[$i]\/$passwd[$i]\@$instance[$i] log = $file_dir$owner\_$table.log"; system ( $CommandString ); if (failed) { ......... } How do I define ...
    Shao, ChunningShao, Chunning
    Nov 19, 2002 at 5:46 pm
    Nov 20, 2002 at 6:09 am
  • Hi folks, I'm closely (re)scrutinising the DBD::Informix doco for 1.00.PC1 and notice that it says Note that you cannot specify ChopBlanks in [the attribute] list [for connect]. Now, I am passing it, ...
    Andrew HammAndrew Hamm
    Nov 8, 2002 at 6:38 am
    Nov 20, 2002 at 4:21 am
  • I get an error when I attempt a query for a specific CUST_ACCT using code like this.... --------------- my $sth = $dbh- prepare("select * from CHSTX_WEB_INVOICE where CUST_ACCT = $quotedcust_no ORDER ...
    Ailes, KevinAiles, Kevin
    Nov 15, 2002 at 7:59 pm
    Nov 15, 2002 at 8:41 pm
  • Can anyone make since of what I'm missing? Thanks! $ perl -v This is perl, v5.6.1 built for i386-linux $ ./kvert.pl install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC (@INC contains: ...
    Nicholas MarshNicholas Marsh
    Nov 13, 2002 at 9:43 pm
    Nov 13, 2002 at 10:47 pm
  • [Please respond directly to me as this address is not subscribed to this list - thnx] When I parameter bind and execute() I get seemingly-subtle errors related to quoting. my $sth = $dbh- ...
    Rob LeeRob Lee
    Nov 12, 2002 at 5:27 pm
    Nov 12, 2002 at 8:22 pm
  • Hi, I am trying to compile DBI using mingW, and I was wondering if anyone has been able to do so. The package does not compile out of the box. Is there any documentation on using perl and mingw32 ...
    Raphi NetRaphi Net
    Nov 11, 2002 at 7:40 am
    Nov 12, 2002 at 3:46 am
  • After several months away from the DBI list I have returned but as usual with new members it is with a question. I'm not sure if I've coded it incorrectly or ran into a glitch in the DBD for ...
    Roderick A. AndersonRoderick A. Anderson
    Nov 9, 2002 at 10:21 pm
    Nov 10, 2002 at 4:54 pm
  • I am writting a script using DBI::Oracle to insert user account into database, before inserting I need to verify to make sure userid is not already existed. I have script written, ran it but nothing ...
    Nguyen, David MNguyen, David M
    Nov 8, 2002 at 6:39 am
    Nov 10, 2002 at 11:25 am
  • Currently I have a Perl app that reads a config file and creates an SQL "where" clause. For legacy reasons, the clause comes out like this: where group=1001 or group=1005 or group=1017 or group=1025 ...
    Chuck TomasiChuck Tomasi
    Nov 8, 2002 at 2:40 pm
    Nov 8, 2002 at 6:20 pm
  • Hello, I was told by my Oracle DBA that all traffic to and from the Database needs to be encrypted. With Oracle 8i, Net 8 handles this. So my question is how can I take advantage of that? Thanks Joe
    Harnish, JoeHarnish, Joe
    Nov 7, 2002 at 4:59 pm
    Nov 8, 2002 at 5:15 pm
  • Thunder - one of my team members had access to another Oracle instance that WAS in the tnsnames.ora file on my box. We ran the 'test_connect_pgm' and got the SAME ERROR as the *.t test modules ...
    Rose, BillRose, Bill
    Nov 5, 2002 at 9:05 pm
    Nov 6, 2002 at 3:38 pm
  • Hi, I ran into some problems while installing DBI on our new system. At first it was a class A failure but after I changed esql's COPTS variable to "", I was able to create a Makefile and run "make" ...
    Gelbolingo, Arlene - MLGGelbolingo, Arlene - MLG
    Nov 4, 2002 at 8:13 pm
    Nov 5, 2002 at 6:08 pm
  • It loads without problem. It makes without problem. But running tests I get an error stating: PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/opt/perl5/lib/5.6.0/PA-RISC2.0 ...
    Beckmann, GaryBeckmann, Gary
    Nov 1, 2002 at 11:46 pm
    Nov 4, 2002 at 8:18 pm
  • Hi, I tried to connect to a Oracle 9i db (system as sysdba) with the following: my $dbh = DBI- connect('dbi:Oracle:AM922X', 'system', 'pass1', { ora_ession_mode = 2 }); and I got the following: DBI- ...
    Lin FengLin Feng
    Nov 27, 2002 at 4:18 am
    Nov 29, 2002 at 2:28 am
Nov 2002
1234
Group Navigation
period‹ prev | Nov 2002 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions160
posts528
users188
websitedbi.perl.org

188 users for November 2002

Tim Bunce: 40 posts Michael A Chase: 37 posts Jeff Urlwin: 19 posts David Wheeler: 13 posts Rose, Bill: 13 posts Ronald J Kimball: 11 posts Paul Boutros: 10 posts Sterin, Ilya (I.): 9 posts Steve Baldwin: 9 posts Wiggins: 8 posts Jared Still: 8 posts Jonathan Leffler: 8 posts Bart Lateur: 7 posts Hardy Merrill: 7 posts Kipp, James: 7 posts Michael Peppler: 7 posts Armand Brisson: 6 posts Chris Faust: 6 posts Mark Buckle: 6 posts Roderick A. Anderson: 6 posts
show more
Archives