FAQ

Search Discussions

175 discussions - 509 posts

  • My program terminates with this error: Can't locate object method "CursorName" via package "DBI::st" at ./test.pl line 17. Issuing rollback() for database handle being DESTROY'd without explicit ...
    Hallvard B FurusethHallvard B Furuseth
    Aug 23, 2002 at 9:11 am
    Nov 26, 2002 at 3:36 pm
  • hello guys, this is more of a perl/SQL problem but in case someone knows, I am trying to make a select statement that filters all name that ends in starts with A and ends in [5-9] something like: ...
    Jonathan Christopher S. RiveraJonathan Christopher S. Rivera
    Aug 5, 2002 at 7:05 am
    Aug 7, 2002 at 4:16 am
  • Hello, I'm introducing myself to DBI and I was wondering if it was possible to connect to a remote database. I've encountered many code examples , and the standard connection method seems to go like ...
    Quoc-Dien TrinhQuoc-Dien Trinh
    Aug 6, 2002 at 6:09 pm
    Aug 7, 2002 at 6:30 pm
  • hi [please CC as i'm not on the list] DBI has a real problem: input/output of date/time/timestamp values. each driver handles it different. most of the drivers returns string, but all in a different ...
    Daniel RitzDaniel Ritz
    Aug 4, 2002 at 2:25 pm
    Aug 7, 2002 at 2:29 pm
  • Hi, I am wondering how to successfully connect to Microsoft Access database using DBD::ODBC. Here is the snippet of my code: ..... my $dbdrive=DBI- install_driver('ODBC'); my $dbn="driver=Microsoft ...
    Liu HaifengLiu Haifeng
    Aug 28, 2002 at 9:16 am
    Sep 3, 2002 at 1:27 am
  • Hi, I am trying to create a new class that inherits from DBI. However, I cannot seem to get it working properly: -- my new class -- package Db; use base DBI; use strict; sub hello { my($self) = ...
    John CoyJohn Coy
    Aug 23, 2002 at 10:15 pm
    Aug 29, 2002 at 11:47 pm
  • Are you sure? This is default Oracle behaviour, and does not belong with me, but with dbi-users You should also specify the versions of DBI and DBD::Oracle you use -- H.Merijn Brand Amsterdam Perl ...
    H.Merijn BrandH.Merijn Brand
    Aug 29, 2002 at 2:29 pm
    Sep 10, 2002 at 9:01 pm
  • Here is the deal : I have a script that does quite a bit mysql manipulation everything works super except one simple delete statement print $query; This is copied and pasted from the above print ...
    Dan MueyDan Muey
    Aug 27, 2002 at 6:26 pm
    Aug 29, 2002 at 8:11 am
  • Hi, After executing perl Makefile.pl for DBD-ODBC-0.43 on solaris 2.7 I get the following "warning" messages. Can they safely be ignored? 1) Multiple copies of Driver.xst found in: ...
    Levine, Peter WLevine, Peter W
    Aug 21, 2002 at 6:33 pm
    Aug 23, 2002 at 12:39 pm
  • Hello all, I need to create couple of stored procedures that return values. As far as I understand store-procs don't return values as Oracle functions do, but a function cannot return more than one ...
    Rozengurtel, DanielRozengurtel, Daniel
    Aug 6, 2002 at 7:51 pm
    Aug 21, 2002 at 2:05 am
  • Hi: I'd like to use DBI in my CGI script but cannot see how I can connect to the database without explitly coding the database name/user & password such as: $dbh = DBI- connect("DBI:mysql:123", ...
    RfkRfk
    Aug 6, 2002 at 2:34 am
    Aug 6, 2002 at 5:09 pm
  • Hi All, I want to migrate to migrate some existing Sybase Perl Programs to work with ORACLE 9. Would it be better to go for DBD::ODBC or DBD:ORACLE. Thanks in Adavance, Arun Outgrown your current ...
    Arun aroraArun arora
    Aug 18, 2002 at 4:29 am
    Oct 25, 2002 at 10:00 pm
  • Hi All, We're seeing some very odd behavior with using alarm() around the DBI- connect() call only on Solaris platforms. It appears that even though we clear the alarm after a successful connection, ...
    Joe SlagelJoe Slagel
    Aug 12, 2002 at 10:30 pm
    Sep 10, 2002 at 9:28 am
  • Hello dbi-users, It seems that DBD::Oracle port incorrectly handles null blobs. I don't know if it is ActiveState specific problem. Any suggestions? This is perl, v5.6.1 built for ...
    Andrew LuckovenkoAndrew Luckovenko
    Aug 20, 2002 at 9:25 pm
    Aug 24, 2002 at 11:30 am
  • HI All, Please refer to the attached document that you might need for any future references to build the right Perl (5.6.1) and DBI/DBD on HP UX 11.0(64 BIT) against Oracle9i . Thanks Sanjay ...
    WAZA,SANJAY (Non-HP-PaloAlto,ex1)WAZA,SANJAY (Non-HP-PaloAlto,ex1)
    Aug 19, 2002 at 6:15 pm
    Aug 21, 2002 at 9:26 am
  • An Ima::DBI user recently pointed out that DBI- connect_cached is not using Apache::DBI like DBI- connect does and DBI- connect_cached has slightly different semantics from Apache::DBI. sub ...
    Michael G SchwernMichael G Schwern
    Aug 9, 2002 at 6:54 pm
    Aug 19, 2002 at 1:24 pm
  • Currently, I pass in sql strings as a quoted string, and single quotes around variables like this: $sql="select * from table where column='$code' "; I now am encountering data that contains a single ...
    Vorce, Tim (T.)Vorce, Tim (T.)
    Aug 15, 2002 at 12:59 pm
    Aug 16, 2002 at 2:29 pm
  • I am looking at the lines of code where my make test fails according to the error output (see platform info and output in previous thread included below). Here are the lines that fail: failing on ...
    Mitchel, Jennifer (Jem)Mitchel, Jennifer (Jem)
    Aug 13, 2002 at 4:08 pm
    Aug 14, 2002 at 7:34 pm
  • Hello there I detected a problem, but still haven't found exactly where the BUG is. A brief sumup follows: OS: SunOS 5.7 DBI: DBI-1.30 DBD: DBD-ODBC-0.43 remote DB: M$oft Sql Server 2000 FreeTDS: ...
    DbiDbi
    Aug 8, 2002 at 10:53 am
    Aug 9, 2002 at 5:25 am
  • All, Having difficulty with an error message "no statement executing" against the following my $dbh = DBI- connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0, RaiseError = 0, PrintError = 0 }) or ...
    Michael DalzielMichael Dalziel
    Aug 29, 2002 at 9:32 am
    Aug 29, 2002 at 1:13 pm
  • Hi with perl 5.8/ apache 2.0.40 / mod_perl 1.99_05 / DBI 1.30 "use DBI " in the startup.pl (before child cloning process) script makes apache segfault in perl 58.dll this is on win32 here is the ...
    Pascal barbedorPascal barbedor
    Aug 17, 2002 at 7:03 pm
    Aug 26, 2002 at 7:24 am
  • In the following code (out of Paul DuBois' book): $dbh- do (qq{ UPDATE todo SET content =?, status = ?, WHERE id = ? }, undef, $content, $status, $id); Why is "undef" listed as an argument? Given ...
    WillWill
    Aug 23, 2002 at 7:03 am
    Aug 23, 2002 at 8:30 pm
  • Hi All, I'd like to submit a simple patch that causes the DBI connect() method to execute a HandleError code reference if it has one. There's a comment suggesting that it could be added, and it makes ...
    David WheelerDavid Wheeler
    Aug 22, 2002 at 5:00 am
    Aug 22, 2002 at 5:25 pm
  • I am running this simple script on HP UX 11.0 (64 BIT) . The database is Oracle 9.2.0 #!/opt/perl5.6.1/bin/perl use DBI; print "hello\n" ; $dbh = DBI- connect(mydb,scott,tiger,'Oracle') ; I am ...
    WAZA,SANJAY (Non-HP-PaloAlto,ex1)WAZA,SANJAY (Non-HP-PaloAlto,ex1)
    Aug 18, 2002 at 3:10 am
    Aug 18, 2002 at 7:39 pm
  • Hello, I got a problem with multiple oracle client installations on a machine. We run an application which currently needs to run with the Oracle 8.1.5 client libraries. Our Perl 5.6.1 DBD::Oracle ...
    Kai JendrianKai Jendrian
    Aug 13, 2002 at 8:19 pm
    Aug 14, 2002 at 1:08 pm
  • Respected Sir/Madum, i am new in perl and i know the basic perl coding. i am presently working on Win_2000 server with Oracle8i(8.1.5.0 version) as database. For trial i have worked on MySQL ...
    Mukund Prakash KambleMukund Prakash Kamble
    Aug 6, 2002 at 9:31 am
    Aug 7, 2002 at 4:20 pm
  • Hello, I recently read about changes of LOB handling that took place in 8.1.6 and 9i, support for binding more than 4000 bytes of data to internal LOBs and SQL like functions for LOBs, and that got ...
    Honza PazdzioraHonza Pazdziora
    Aug 5, 2002 at 7:36 pm
    Aug 6, 2002 at 3:30 pm
  • I was planning on using XML::Parser to output results in xml after extracting data from Oracle . (Installation of DBD and DBI ony HP seems to work fine ). As per the instructions in Release notes for ...
    Kairam, RajKairam, Raj
    Aug 5, 2002 at 6:33 pm
    Aug 6, 2002 at 12:42 pm
  • Hello, In an attempt to add some custom logging into DBI calls, I have over-ridden the execute method of DBI with a custom execute method. The project I have includes writing out the SQL statement ...
    Mark_hickmanMark_hickman
    Aug 29, 2002 at 10:17 pm
    Sep 9, 2002 at 9:41 pm
  • Hi, I'm still trying to update through a cursor, and I still can't get it to work. The program fails at statement- execute(value) with the message DBD::Oracle::st execute failed: ORA-00936: missing ...
    Hallvard B FurusethHallvard B Furuseth
    Aug 31, 2002 at 9:28 am
    Sep 9, 2002 at 2:07 pm
  • Using oracle 8.1.7, perl 5.6.1, DBD::Oracle 1.12. When I do an insert like this below on CT.COL, a varchar2(10): $c = $dbh- prepare( 'insert into ct (COL) values (?)'); $c- execute('bind '); The ...
    Mark DedlowMark Dedlow
    Aug 27, 2002 at 2:43 am
    Aug 27, 2002 at 1:33 pm
  • Hi, I'm using DBI in a cgi-bin script. I can't find a way to suppress the error message "DB-Library: Login incorrect" if DBI- connect fails. This is an issue because the raw output causes a web ...
    Levine, Peter WLevine, Peter W
    Aug 19, 2002 at 7:39 pm
    Aug 20, 2002 at 1:43 pm
  • Hi, I need the return value from a stored procedure. Usually I do like this: $sth = $dbh- prepare('Declare @RETURN_VALUE int; exec @RETURN_VALUE=some_procedure @param0=?, @param1=?; select ...
    Roger PerttuRoger Perttu
    Aug 15, 2002 at 3:51 pm
    Aug 19, 2002 at 7:47 pm
  • Your message shows you migrating from Sybase to Oracle. What about when the customer (or your mgt) decides to use DB2? The other points are quite valid, but ask yourself about future DB changes or ...
    Bill CowanBill Cowan
    Aug 18, 2002 at 7:58 pm
    Aug 18, 2002 at 10:27 pm
  • I'm doing some testing with perl 5.8.0 and trying to use DBI. I know that the DBI and ithreads are listed as beta and not production ready, but the problem I think I'm having is that this fails to ...
    Scott AlexanderScott Alexander
    Aug 10, 2002 at 1:15 am
    Aug 17, 2002 at 5:40 pm
  • I have encountered a peculiar problem involving the DBI, although I have no evidence to suggest the DBI is the cause of the problem. I am running Solaris 8 and using the iPlanet 6.0 (I guess now ...
    DarrefoDarrefo
    Aug 16, 2002 at 6:42 pm
    Aug 16, 2002 at 8:07 pm
  • Hi, I'm using DBD::Oracle, and Perl 5.005. The problem is this: I'm trying to insert a space into a primary key column. If I do this: my $sth = $dbh- prepare("insert into my_table values ...
    Miller, IainMiller, Iain
    Aug 16, 2002 at 12:30 pm
    Aug 16, 2002 at 8:02 pm
  • Hi, Is anyone out there using a RDBMS data modeling tool on Linux. I've looked around but haven't found anything. Thanks in advance for the help. -Ian
    Ian HarisayIan Harisay
    Aug 15, 2002 at 4:53 pm
    Aug 15, 2002 at 11:03 pm
  • I am having a bit of difficulty with my perl scripts on MAC OSX laptop. I have used perl scripts to populate sql tables as recently as last week. This week when I tried to use another script I got an ...
    Mike KnichelMike Knichel
    Aug 14, 2002 at 11:50 am
    Aug 14, 2002 at 11:55 pm
  • Any thoughts on using the new DBI feature, specifying maxrows in a fetchall_arrayref? If I use something like while ( my $array_ref=$sth- fetchall_arrayref(undef, $maxfetch)) { # ... do something } I ...
    Fox, MichaelFox, Michael
    Aug 13, 2002 at 10:16 pm
    Aug 14, 2002 at 11:23 pm
  • I've struck a problem in binding a date to a DBI prepared statement, to send to Oracle8i. I declared a variable: $dbtimestamp="TO_DATE('$db_ts', 'DD-MM-YYYY HH24:MI:SS')" ; The string $db_ts is from ...
    Max HugenMax Hugen
    Aug 13, 2002 at 7:01 am
    Aug 14, 2002 at 12:52 am
  • Does anybody have a way to deal with user input containing a '\' from a cgi form into a mysql database? Or do I have to do regex to escape user input, escape the database input and escape the ...
    RwilbertRwilbert
    Aug 13, 2002 at 3:46 pm
    Aug 13, 2002 at 5:57 pm
  • I probably need to add dates, that's true. I have now, in DBD::ODBC::Changes.pm (which will be installed in the newest version. perldoc DBD::ODBC::Changes will now get you the change log. I'm going ...
    Jeff UrlwinJeff Urlwin
    Aug 9, 2002 at 11:14 pm
    Aug 12, 2002 at 2:38 pm
  • I'am parsing a text field delimited by ; (see example belown). I split the file into multiple variable ($) and then execute the request. When the NO is blank: no problem the record is write inside DB ...
    Stephane Legault/Quebec/IBMStephane Legault/Quebec/IBM
    Aug 9, 2002 at 5:36 pm
    Aug 10, 2002 at 1:33 am
  • I try to read date/time from times_tamp column in my oracle database but I could not read it using SQL query. Is it a way to resolve it? SQL select time_stamp from user_activity_log; TIME_STAMP ...
    Nguyen, David MNguyen, David M
    Aug 8, 2002 at 10:41 pm
    Aug 9, 2002 at 1:05 am
  • Hello all, I wanted to write a general error handler but got stuck trying to print the last executed SQL statement. Under http://perlmonks.org/index.pl?node_id=188269 I opened a discussion about it ...
    Axel RoseAxel Rose
    Aug 8, 2002 at 9:52 am
    Aug 8, 2002 at 2:38 pm
  • DBD::Oracle is giving me this error: <- prepare('UPDATE report_distribution SET current_status_desc='COMPLETED', attempts=?, result=?, completed_timestamp=? WHERE job_id=?')= DBI::st=HASH(0x83d158c) ...
    GphatGphat
    Aug 6, 2002 at 6:52 pm
    Aug 6, 2002 at 7:10 pm
  • Set up DBD::JDBC to use a (god help me) a Microsoft supplied JDBC driver for MS SQL Server 2000. Can't seem to get past the error: install_driver(JDBC) failed: Bareword "SQL_BIGINT" not allowed while ...
    Marc FrancoeurMarc Francoeur
    Aug 30, 2002 at 5:13 pm
    Sep 9, 2002 at 9:35 pm
  • Hi, I think DBI is messed up. I recently switched to Oracle9i from 8i and the same exact perl code stopped working!!! Here's my problem: This statement works (please don't ask why I use begin/end, I ...
    Saman RanatungaSaman Ranatunga
    Aug 30, 2002 at 10:25 pm
    Sep 3, 2002 at 4:53 pm
  • Sorry if there was a question already. Is there a good dbi with perl book? Thanks.
    Michele FrancisMichele Francis
    Aug 30, 2002 at 10:45 pm
    Sep 1, 2002 at 8:52 pm
Group Navigation
period‹ prev | Aug 2002 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions175
posts509
users211
websitedbi.perl.org

211 users for August 2002

Michael A Chase: 45 posts Tim Bunce: 44 posts Jeff Urlwin: 34 posts Levine, Peter W: 8 posts David Wheeler: 7 posts Jeff Zucker: 7 posts Andrew Luckovenko: 6 posts Dan Muey: 6 posts David Dooling: 6 posts Kipp, James: 6 posts Michael Peppler: 6 posts Fox, Michael: 5 posts Hardy Merrill: 5 posts Jared Still: 5 posts Roger Perttu: 5 posts Ronald J Kimball: 5 posts Steven Lembark: 5 posts Arun arora: 4 posts Bart Lateur: 4 posts Jonathan Christopher S. Rivera: 4 posts
show more
Archives