FAQ

Perl > dbi-users > January 2005

Search Discussions

91 discussions - 291 posts

  • The following line produces and error in DBI excuting with either a do or a prepare, execute my $statement = "SELECT \"Rows inserted\" + @rows "); # ODBC error my $statement2 = "SELECT 'Rows ...
    Moosmann, JamesMoosmann, James
    Jan 18, 2005 at 9:11 pm
    Jan 23, 2005 at 3:08 am
  • Hello, I'm having trouble getting the FAQ section of your website. Our firewall won't allow it. I have two users using Oracle 10 and Oracle 8.1.7. I've already installed DBI for Oracle 10 but now the ...
    Sandra DurbinSandra Durbin
    Jan 5, 2005 at 9:07 pm
    Jan 13, 2005 at 9:34 pm
  • Hi all. I've just ( barely ) managed to get DBD::ODBC == UnixODBC == FreeTDS working on my system. I took a Perl-Gtk2 app which has been running fine, and substituted the old DBD::Sybase connection ...
    Daniel KasakDaniel Kasak
    Jan 12, 2005 at 12:12 am
    Jun 28, 2005 at 7:57 am
  • Hi all, I have a question: I use DBI and DBD::Oracle with no prob. but I need to retur the number of rows affected by a select statement, use the "$var = $st- rows" but it no works in select ...
    Hernan ArredondoHernan Arredondo
    Jan 24, 2005 at 6:42 pm
    Jan 25, 2005 at 1:20 am
  • I am trying to figure out the most efficient method of passing around a live dbh when calling a subs. I have embedded a dbh into an object: $obj- {dbh} and would like to pass to it to other functions ...
    Alec BrecherAlec Brecher
    Jan 10, 2005 at 3:36 pm
    Jan 10, 2005 at 6:17 pm
  • Hello, I have succesfully installed freetds-0.62.3-1.1.fc3.rf from Dag Wieers's rpm repository unixODBC-2.2.9-42 unixODBC-devel-2.2.9-42 from Fedora Core 3's rpm repository DBD::ODBC 1.13 from ...
    Honza PazdzioraHonza Pazdziora
    Jan 4, 2005 at 8:55 am
    Jun 27, 2005 at 9:08 pm
  • Hello, After I've upgraded to newest versions of DBI(1.46) and DBD::Pg (1.32), my scripts started to fail while feeding arrays into stored procedures in postgresql base (v7.4.6). The (old working) ...
    Dmitry KarasikDmitry Karasik
    Jan 17, 2005 at 2:06 pm
    Jan 23, 2005 at 7:50 am
  • Hi all. I'm after a driver for SQL Server. My requirements: - must run on Linux - must support placeholders - must work with SQL Server 7 That's it. To show I've researched a bit: I'm currently using ...
    Daniel KasakDaniel Kasak
    Jan 11, 2005 at 3:06 am
    Jan 11, 2005 at 4:50 pm
  • Hello: I am using perl version 5.8.5 to connect to Oracle 7.3.4 database. I can fetch Date, Number, Float type of data from that database, but not VARCHAR2 type of data. The error message is: ...
    Yahui ShangYahui Shang
    Jan 9, 2005 at 12:57 am
    Jan 10, 2005 at 10:22 pm
  • Hi, I'm running a test to see whether certain criteria in a SELECT statement return record or not. If I get a "no rows selected" from SQL then I want to perform a specific action . But I don't how ...
    Mark MartinMark Martin
    Jan 28, 2005 at 12:57 pm
    Jan 31, 2005 at 10:34 am
  • I just read a Debian advisory about CAN-2005-0077, claiming "Javier Fernández-Sanguino Peña from the Debian Security Audit Project discovered that the DBI library, the Perl5 database interface, ...
    Peter J. HolzerPeter J. Holzer
    Jan 28, 2005 at 3:27 pm
    Jan 28, 2005 at 10:24 pm
  • Hi all, I make a page that returns the result of a select statement in Perl and DBI, but a lot of rows are returned, there is a way to page the result ? Regards Hernan Dario -- No matter how fast ...
    Hernan ArredondoHernan Arredondo
    Jan 25, 2005 at 10:01 pm
    Jan 27, 2005 at 4:54 pm
  • Hi, I am using Linux Debian (Sid) with libdbi-perl version 1.46-5 and mySQL version 4.1. Currently, I am trying to set up a perl script which will use the DBI module to connect to database. ...
    Wojciech KarlowskiWojciech Karlowski
    Jan 26, 2005 at 2:19 pm
    Jan 26, 2005 at 7:39 pm
  • Hello, the following program: use strict; use DBI; my $dbh = DBI- connect(qw( dbi:Oracle: T3_JLL T3_JLL ), { PrintError = 0 }); $dbh- do(q{DROP TABLE Person}); $dbh- disconnect; $dbh = DBI- ...
    LEROY Jean-LouisLEROY Jean-Louis
    Jan 21, 2005 at 10:55 am
    Jan 21, 2005 at 3:24 pm
  • Gentlemen: I have struggled with this problem for a while now with no success at finding the answer, so I am asking for help from anyone who might know the solution. I am using Windows XP, ...
    Charles LawrenceCharles Lawrence
    Jan 18, 2005 at 7:55 pm
    Jan 19, 2005 at 6:53 pm
  • Hi all, I'm new in DBI and I'm really stuck, some can explain me this code: use DBI; my $dbh = DBI- connect( 'dbi:Oracle:db', '$username', '$passwd', ) or die "$DBI::errstr"; EOF its supposed I get a ...
    Hernan ArredondoHernan Arredondo
    Jan 13, 2005 at 7:11 pm
    Jan 13, 2005 at 7:50 pm
  • I'm running the following: Win2k ActiveState Perl 5.6.1 DBI 1.28 DBD-Oracle 1.06 DBD-mysql 2.04 In order to utilize Win32-Printer, I need to upgrade to Perl 5.8. I've Googled and found nothing that ...
    Michael RagsdaleMichael Ragsdale
    Jan 7, 2005 at 3:09 pm
    Jan 9, 2005 at 8:49 pm
  • hello world I'm pretty new to make Oracle and perl together. I test a very simple request with TOAD and its cool sql editor : delete from MYTABLE where (NAME< 'UNKNOWN' and ID=123); Simple, isn't it ...
    LiooilLiooil
    Jan 4, 2005 at 3:31 pm
    Jan 4, 2005 at 4:27 pm
  • I'm trying to select from a table where the serial number apparently looks like an octal number to Oracle and I haven't been able to figure out how to convince it otherwise. My last attempt looks ...
    Jim LynchJim Lynch
    Jan 25, 2005 at 7:27 pm
    Oct 27, 2005 at 1:17 pm
  • Hi all! I have subroutine, that checks, if I already have in DB specified row: sub image_exist { my ($id, $date) = @_; #id is _always_ number my $sth = $mydbh- prepare_cached("select ID from pic ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    Jan 28, 2005 at 8:56 am
    Jan 28, 2005 at 2:27 pm
  • Hello I have on my server 5.005_03 built for sun4-solaris installed with DBI(v1.13). I was previously accesing a Oracle 7.3.4 Database without problems. Now I tried to access the same DB but migrated ...
    Spiraquis Alexis (SFO)Spiraquis Alexis (SFO)
    Jan 24, 2005 at 6:45 pm
    Jan 25, 2005 at 4:10 pm
  • Hi: Send me the PPM package for DBD::Oracle. Activestate 5.8 Best Regards, Satish Waghmare
    Waghmare, Satish (IE03x)Waghmare, Satish (IE03x)
    Jan 17, 2005 at 10:20 am
    Jan 25, 2005 at 2:18 pm
  • Hello, I'm using DBI and DBD:ODBC in my perl script. I'm also using DBI::Const::GetInfoType. I was trying to get the database name using $dbh- get_info( $GetInfoType{SQL_DATABASE_NAME} ), and it ...
    Phillip HellewellPhillip Hellewell
    Jan 21, 2005 at 7:03 pm
    Jan 25, 2005 at 11:11 am
  • Error Message is [Tue Jan 25 04:53:23 2005] [error] [client 127.0.0.1] DBD::Oracle::db prepare failed: ORA-00900: invalid SQL statement (DBD: error possibly near <* indicator at char 1 in '<* DESC ...
    Vivekananda MarellaliVivekananda Marellali
    Jan 24, 2005 at 11:21 pm
    Jan 25, 2005 at 1:58 am
  • Hi, I have an app which connects via DBI:DBD:CSV to a flat file. When I include pragma use encoding, the app aborts (message from OS and the script is killed). I found out that script is aborted ...
    RHRH
    Jan 21, 2005 at 4:04 pm
    Jan 24, 2005 at 9:16 am
  • Hello, I'm having a very strange problem with DBD::Proxy and have ended up with brain meltdown - so now its your turn ;-) Basically, if I use DBD::Proxy to connect to a database (just doing a 'use ...
    Addison, MarkAddison, Mark
    Jan 19, 2005 at 5:37 pm
    Jan 21, 2005 at 4:39 pm
  • Nina MarkovaNina Markova
    Jan 19, 2005 at 8:12 pm
    Jan 20, 2005 at 12:56 pm
  • Oracle 8.1. I'm finding that for a REQUEST_DATE value of 25-May-01:- WHERE BLAH.REQUEST_DATE <= TO_DATE('25-MAY-01', 'DD-MON-YY') yields nothing, while WHERE BLAH.REQUEST_DATE = TO_DATE('25-MAY-01', ...
    Graeme St. ClairGraeme St. Clair
    Jan 18, 2005 at 11:56 pm
    Jan 19, 2005 at 12:30 am
  • Hi, I'm using perl with Ingres driver. My question is how to set readlock=nolock via perl dbi. Normally via eSQL I use EXEC SQL SET LOCKMODE SESSION WHERE READLOCK = NOLOCK; Is there any similar ...
    Nina MarkovaNina Markova
    Jan 4, 2005 at 4:39 pm
    Jan 4, 2005 at 8:23 pm
  • Hi, I'm trying the access oracle through perl, but am getting the error "ERROR OCIEnvInit". My perl script is: ------------------------------------------------------------------------- use DBI; ...
    Sandeep WarikooSandeep Warikoo
    Jan 4, 2005 at 2:55 pm
    Jan 4, 2005 at 4:07 pm
  • hi , am new to perl. plz help me with the following: 1.How to reteive records from postgresql databasse using PERL? here is my code follows: #!/usr/bin/perl print "Content-type: text/html\n\n"; use ...
    Sudheer raghavSudheer raghav
    Jan 28, 2005 at 5:51 am
    Jan 28, 2005 at 10:57 am
  • All, I have the following code: $::sql = "INSERT into MASTER_Issue"; $::sql.= " (idIssue, Description, OpenDate, DueDate, idStatus, idPriority, idSeverity, SortDate)"; $::sql.= " VALUES ...
    Moreno, JavierMoreno, Javier
    Jan 26, 2005 at 4:44 pm
    Jan 26, 2005 at 5:47 pm
  • I have a strange problem when connecting to an Oracle 10 database: #!/usr/bin/perl use strict; use warnings; use DBI; my $rc = system "true"; print "Before: $rc\n"; my $dbh = DBI- ...
    Peter MarksteinerPeter Marksteiner
    Jan 25, 2005 at 2:51 pm
    Jan 25, 2005 at 6:16 pm
  • Sorry if I posted this twice - I did not see my first post go through. I am trying to do a join across to csv files but have been unsuccessful up to this point. I have two tables: tab1.csv ...
    Jeff BentonJeff Benton
    Jan 13, 2005 at 8:01 pm
    Jan 24, 2005 at 10:06 pm
  • Greetings - Having the notorious problem where trailing spaces are being truncated from bind variables. I have found two solutions, one is to rtrim the column in the SQL statement, the other is to ...
    Chad TerryChad Terry
    Jan 21, 2005 at 4:20 pm
    Jan 21, 2005 at 6:12 pm
  • On occassions when an oracle instance is having trouble, my DBI connections hang. For example, if the oracle archive log destination is full or the OS itself is hung, the DBI connection will also ...
    David GoodmanDavid Goodman
    Jan 20, 2005 at 5:00 pm
    Jan 20, 2005 at 5:16 pm
  • OK, I am facing a bit of a dilema here. I am trying to help a group of developers convert a blog system to Oracle. This system was originally written for Mysql but would be great if we could get it ...
    Maldonado, Daniel CW2 CTARNGMaldonado, Daniel CW2 CTARNG
    Jan 18, 2005 at 8:34 pm
    Jan 18, 2005 at 8:37 pm
  • All, Does anyone know of a repository where I can find DBD::Oracle? I have tried the ActiveState default repository but it reports it is not available. Regards, Javier Moreno
    Moreno, JavierMoreno, Javier
    Jan 17, 2005 at 5:05 pm
    Jan 17, 2005 at 7:22 pm
  • Hi all, I am using the Apache webserver bundled with Oracle PE and I am getting the following error: [Sat Jan 15 10:34:41 2005] [error] [client 151.110.117.153] DBI connect('ILOG','system',...) ...
    Moreno, JavierMoreno, Javier
    Jan 15, 2005 at 4:44 pm
    Jan 16, 2005 at 5:10 pm
  • Patrick M AlbouyPatrick M Albouy
    Jan 15, 2005 at 1:09 am
    Jan 15, 2005 at 12:53 pm
  • mandating a new method for all compliand DBDs is, as ever, outrageeous. Here's a proposed compromise: A new DBD that takes the elements of the attributes hash, and at connect time this DBD will build ...
    David NicolDavid Nicol
    Jan 13, 2005 at 6:40 am
    Jan 13, 2005 at 12:26 pm
  • Help! I have a SQL SERVER database hosted on an NT server. I am trying to connect to the database using PERL from LINUX. I am currently using DBD::ODBC but the multiple query restriction is causing ...
    Pothier RaPothier Ra
    Jan 12, 2005 at 1:48 pm
    Jan 12, 2005 at 4:59 pm
  • Linux version: Linux agumbe.p.in.integral.com 2.4.20-8 #1 Thu Mar 13 17:54:28 EST 2003 i686 i686 i386 GNU/Linux Oracle client: 9.2.0 DBD::Oracle: DBD-Oracle-1.16 Following error when installing, I ...
    Shiva kumarShiva kumar
    Jan 11, 2005 at 7:23 am
    Jan 12, 2005 at 4:41 am
  • Hello, First of all, thank you for taking the time to help me. I am a beginner to DBI, and I am very frustrated with not being able to connect to Oracle from my Sun Solaris box. I installed DBI and ...
    Zhou, QingZhou, Qing
    Jan 9, 2005 at 12:45 am
    Jan 10, 2005 at 12:48 am
  • Hi, I am using perl DBI Most of my perl code use prepared statements like this my $datasource = "dbi:Oracle:"; $abdw_dbh = DBI- connect("$datasource", "$abdw_username/$abdw_password\@$abdw_sid") or ...
    Sunil A.V.Sunil A.V.
    Jan 7, 2005 at 10:30 pm
    Jan 8, 2005 at 3:22 pm
  • I am currently developing a module/framework that is focused on enabling cross-database portability that is as thorough as the Java platform does cross-platform portability. In practice, this module ...
    Darren DuncanDarren Duncan
    Jan 6, 2005 at 11:42 pm
    Jan 7, 2005 at 7:10 am
  • Hi, I am trying to connect to an oracle database using the following strings: $db_handle = DBI- connect("dbi:Oracle:db_name",username, pwd); or $db_handle = DBI- connect("db_name","username","pwd"); ...
    Boris VolfBoris Volf
    Jan 4, 2005 at 6:34 pm
    Jan 6, 2005 at 9:54 am
  • Hi, I have a problem trying to make a few queries work with parameter binding: This code works fine: use DBI; use DBD::Oracle qw(:ora_types); my $dbh = DBI- connect($dsn,$user,$password); my $sth = ...
    Juan Jose NateraJuan Jose Natera
    Jan 31, 2005 at 9:34 pm
    Jan 31, 2005 at 11:21 pm
  • While installing DBD::Oracle I got the following errors: t/40ph_type.............Can't load '/root/.cpan/build/DBD-Oracle-1.16/blib/arch/ auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ...
    Maldonado, Daniel CW2 CTARNGMaldonado, Daniel CW2 CTARNG
    Jan 31, 2005 at 8:20 pm
    Jan 31, 2005 at 8:41 pm
  • What is the meaning of result type 4046? I'ts not documented in DBD::Sybase. Thanks, Jim -------------------------------------------------------- NOTICE: If received in error, please destroy and ...
    Anderson, James H (Company IT)Anderson, James H (Company IT)
    Jan 31, 2005 at 6:11 pm
    Jan 31, 2005 at 7:04 pm
Jan 2005
12
Group Navigation
period‹ prev | Jan 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions91
posts291
users116
websitedbi.perl.org

116 users for January 2005

Reidy, Ron: 20 posts Michael A Chase tech: 18 posts Tim Bunce: 12 posts Amonotod: 11 posts Jeff Urlwin: 8 posts Hardy Merrill: 7 posts Daniel Kasak: 5 posts David Goodman: 5 posts Graeme St. Clair: 5 posts Sam Vilain: 5 posts Tony Adolph: 4 posts Darren Duncan: 4 posts Hernan Arredondo: 4 posts JupiterHost.Net: 4 posts Liooil: 4 posts Moosmann, James: 4 posts Moreno, Javier: 4 posts Nina Markova: 4 posts Ronald J Kimball: 4 posts Rudy Lippan: 4 posts
show more
Archives