Search Discussions

28 discussions - 121 posts

  • Hi all, Can someone advise how to set LD_LIBRARY_PATH from within the Perl scripts? If I set LD_LIBRARY_PATH from the command line, all is okay [oracle ~]$ perl -e 'use DBD::Oracle; print ...
    Newbie01 perlNewbie01 perl
    May 28, 2010 at 7:45 am
    Jan 24, 2011 at 2:50 pm
  • I have a question for which I have not been able to find a good answer. I have a Perl application that uses many Perl modules. Most come from CPAN, some I have written, others come with Perl ...
    William BulleyWilliam Bulley
    May 27, 2010 at 6:55 pm
    Jun 1, 2010 at 10:05 am
  • I've a case where a function is called with a string provided by a user, and some legacy code then puts that string into a select statement for dbi. The code currently reads: my ($query) = $dbconn- ...
    Larry W. VirdenLarry W. Virden
    May 3, 2010 at 6:30 pm
    May 7, 2010 at 9:05 am
  • Hi All, I want to know which one of these algorithm would be the most optimized solution to insert large number of records and Why: 1. Preparing an Insert query once and executing it with place ...
    Parag KalraParag Kalra
    May 2, 2010 at 8:21 am
    May 3, 2010 at 1:30 pm
  • I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle, using IBM XL C v11.1 + the latest PTF. to build DBD-Oracle, i had to ...
    John R PierceJohn R Pierce
    May 17, 2010 at 10:05 pm
    Dec 17, 2010 at 4:06 pm
  • I have a sqlite (version 3.6.13) database with 300000+ rows 1500 of these rows have faulty data. So I read the main database row by row, tested the validity of one column, and inserted the good rows ...
    May 26, 2010 at 12:46 am
    Jun 5, 2010 at 2:55 am
  • Hi Tim, I wrote a small script that connect to SQL Server engine.I don't want to give the name of the databse in the connection string.I want to select a db on the fly only if it present.I tried ...
    Mani kandanMani kandan
    May 13, 2010 at 2:59 pm
    May 18, 2010 at 5:37 am
  • If $dbh is my database handle, to roll back the current transaction I do: $dbh- rollback(); right? The DBD::Oracle docs don't explicitly say.... -- Bruce Johnson University of Arizona College of ...
    Bruce JohnsonBruce Johnson
    May 6, 2010 at 6:31 pm
    May 6, 2010 at 6:49 pm
  • I don't suppose anyone has bothered to construct a DBD for h2? http://www.h2database.com/html/main.html the unfortunate choice to name it the same as the level two header html tag makes it somewhat ...
    David NicolDavid Nicol
    May 4, 2010 at 9:23 pm
    May 6, 2010 at 9:12 am
  • Hi everyone, OS: AIX perl version: 5.0 After installed DBD-ODBC-1.21, I run 'make test', but failed 'can't load library' error: t/20SqlServer...........ok 2/65install_driver(ODBC) failed: Can't load ...
    Chunmei WuChunmei Wu
    May 8, 2010 at 4:46 am
    May 10, 2010 at 9:39 am
  • Hi, I've searched the archive at www.mail-archive.com and have not found any references to this specific error number. I've been using a PL/SQL function from Perl DBI this way: $cursor = $dbHandle- ...
    Bob McGowanBob McGowan
    May 26, 2010 at 5:31 pm
    May 26, 2010 at 6:34 pm
  • I'm getting an error when I try to use a "left outer join" in my Perl program. I have not found anything about joins in the documentation of the DBD:Oracle module. I'm using DBD::Oracle v1.18 on Perl ...
    White, Richard LWhite, Richard L
    May 21, 2010 at 4:25 pm
    May 21, 2010 at 7:22 pm
  • 1) output of $perl Makefile.PL Creating test wrappers for DBI::PurePerl: t/zvp_01basics.t t/zvp_02dbidrv.t t/zvp_03handle.t t/zvp_04mods.t t/zvp_05concathash.t t/zvp_06attrs.t t/zvp_07kids.t ...
    Ninu CleetusNinu Cleetus
    May 20, 2010 at 11:00 am
    May 20, 2010 at 5:38 pm
  • Hi, I am trying to query an Oracle database and output the results to a file using PERL but its not working. I have tried 2 approaches. 1 uses bind the other does not. Could you please advise?: Using ...
    May 11, 2010 at 7:25 pm
    May 15, 2010 at 3:32 pm
  • Hi, Am trying out DBI for Oracle and just want to know if for example, I need to include column formatting stuff etc., is it best to just put them into a .sql file and then execute the .sql file ...
    Newbie01 perlNewbie01 perl
    May 30, 2010 at 5:33 am
    May 30, 2010 at 2:18 pm
  • Hi Guys For the past few years have been writing an advanced enterprise monitor for databases My database autodiscovery process is fairly good - but I have one issue. I cant figure out how to fetch ...
    Barlow, EdBarlow, Ed
    May 26, 2010 at 12:37 pm
    May 27, 2010 at 5:43 pm
  • I'm using DBI to interact with ORACLE . I have a number of statements - select, insert, update, and delete - that are executed depending on the logic. When I execute the $handle- do statement, is the ...
    Larry W. VirdenLarry W. Virden
    May 25, 2010 at 12:21 pm
    May 27, 2010 at 4:23 am
  • Dear List, I am experiencing a problem in which, when one node of my 11g RAC fails, all the connections to that node get hung for a while. Some applications support transparent failover, but ...
    May 21, 2010 at 5:27 pm
    May 22, 2010 at 2:01 am
  • any one has success in getting this working.. thanks Srinivas.
    Srinivas aradhyulaSrinivas aradhyula
    May 14, 2010 at 9:46 pm
    May 16, 2010 at 6:18 pm
  • Due to annoying bug a few people are hitting when re-executing a prepared statement with MS SQL Server I've uploaded 1.24_1 development release. Changes since 1.24 are: Corrected pod and private ...
    Martin EvansMartin Evans
    May 28, 2010 at 2:50 pm
    May 28, 2010 at 2:50 pm
  • Hi, all I am using DBD::Oracle 1.23 on an Ubuntu Server 8.04 64 bit system, against latest Instant Client: Client Shared Library 64-bit - System name: Linux Release: ...
    Anselmo CanforaAnselmo Canfora
    May 24, 2010 at 9:31 am
    May 24, 2010 at 9:31 am
  • Greetings, I am pleased to announce that version 0.129.1 of the specification of the Muldis D language, for object-relational databases, has been released on CPAN. This release marks a milestone for ...
    Darren DuncanDarren Duncan
    May 19, 2010 at 8:02 am
    May 19, 2010 at 8:02 am
  • I get a lot of queries to my personal/CPAN email address with connection problems with DBD::ODBC. I've tried to describe the process at http://www.martin-evans.me.uk/node/70 which you may find ...
    Martin J. EvansMartin J. Evans
    May 18, 2010 at 11:10 pm
    May 18, 2010 at 11:10 pm
  • DBIx::Cookbook (http://search.cpan.org/dist/DBIx-Cookbook/) is an extensible collection of modular command-line scripts exemplifying the use of DBI and DBI-based ORMs. Based on the populated, ...
    Terrence BrannonTerrence Brannon
    May 17, 2010 at 1:50 pm
    May 17, 2010 at 1:50 pm
  • I have just uploaded the official 1.24 release of DBD::ODBC to CPAN. Many thanks to everyone who has helped with this whether it was patches or testing. Here are the changes since 1.23: =head2 ...
    Martin EvansMartin Evans
    May 14, 2010 at 4:05 pm
    May 14, 2010 at 4:05 pm
  • Hi Tim, I need your help with connecting perl to analysis services of sql server 2005 via dbi.The default connect goes to database engine.I have to change this and connect to analysis service i.e Sql ...
    Mani kandanMani kandan
    May 13, 2010 at 2:26 pm
    May 13, 2010 at 2:26 pm
  • I've just uploaded the 1.23_5 development release of DBD::ODBC. This will hopefully be the last release before an official 1.24. Below are the changes since 1.23. All testing welcome however, once a ...
    Martin EvansMartin Evans
    May 6, 2010 at 2:59 pm
    May 6, 2010 at 2:59 pm
  • Now that we have DBI-1,611, we can make progress! file: $CPAN/authors/id/H/HM/HMBRAND/DBD-CSV-0.29.tgz size: 27266 bytes md5: dd48f0e3d8fc1211a3c98e2489b78295 New are locking and encoding. Enjoy! ...
    H.Merijn BrandH.Merijn Brand
    May 4, 2010 at 11:57 am
    May 4, 2010 at 11:57 am
Group Navigation
period‹ prev | May 2010 | next ›
Group Overview
groupdbi-users @

50 users for May 2010

John Scoles: 14 posts Martin J. Evans: 13 posts William Bulley: 6 posts Alexander Foken: 5 posts John Scoles: 5 posts Bruce Johnson: 4 posts John R Pierce: 4 posts Larry W. Virden: 4 posts Mani kandan: 4 posts Martin Gainty: 4 posts Parag Kalra: 4 posts Jonathan Leffler: 3 posts Peter J. Holzer: 3 posts Bart Lateur: 2 posts Bob McGowan: 2 posts C. Chad Wallace: 2 posts Chas. Owens: 2 posts Chunmei Wu: 2 posts David McMath: 2 posts Jeffrey Seger: 2 posts
show more