Webmaster Forum / Perl / DBI Library / February 2005

The following exp command ran find on Unix command prompt.
$> exp file=users.dmp transport_tablespace=y tablespaces=USERS
userid=\'sys/syspw@testdb as sysdba\'
When I tried calling it in Perl,

The subroutine below reads a file and assigns values
to variables. It ran fine with the following input
file, file1. However, if I add '#' to the file in the
first couple of lines (file2), it errored.

My DBI perl application needs to support many database servers and
versions, but will only use one database server per installation.  IE:
one customer may be using MySQL v3.xx, while another has PgSQL v7.4,
while another has Oracle... etc.  My application needs to work for them

Is there another way of fetching all table records in one statement
without going through a loop?
What I have now is as follows:
while (@eachrec=$sth->fetchrow_array) {        

I've been asked to write a script to examine new stored procedures to see if
they do any writing (i.e. delete, insert, update) to the database, or,
recursively, if they call any stored procs that write to the database. I
can't just do a simple grep but also have to ignore comments ...

I'm trying to use kerberos authentication with the latest version of
your sybase DBD module (DBD-Sybase-1.05) and the latest version of DBI
(DBI-1.47) on Solaris 8.  I'm using perl 5.8.
Both DBI and the DBD compile just fine.  But when I run a test program I

I'm new to perl. I apologize if this is not the right
place to post newbie questions.
If mytable does not exist, I would like to trap the
Oracle error message and write the message to an

I am having Perl 5.8 version and Oracle 10g installed on Windows
server 2003. I am able to connect as well as execute Oracle queries
from the command line. But wfrom the browser I am not able to connect
to ORACLE database. Please help me.

   One of my present requirement is to support the Oracle DBD for Perl
version 5.005_03 + related DBI version. As of my current analysis with the
Oracle DBD; it says the requirement to have the perl 5.6.1 version. Just
wondering whether is there any Oracle DBD that supports for ...

This is my code.  The truncate works just fine but the return code is  always
-205.  Where is my error?
Thanks
sub truncate_table($$) {

Hi, all
I am experiencing a puzzling problem while trying to get an DBD::ODBC
connection (via unixODBC) working from a client machine A (Suse linux)
to a an ADABAS-D-11 database running on a remote machine (B, also Suse

I need some equivalent of func() function in db2.
In this function I am  calling dbms_output_enable(), dbms_output_put()and
Dbms_output_get().
These are available in dbd:oracle package but not in dbd:db2.

DBI Folks,
   I found the following article:
         http://www.cuddletech.com/articles/oracle/node50.html
   which discusses using the Perl distribution that comes as part of

I have table which consist of cca 20.000.000 rows, using MySQL.
How to do something with each row ? I mean: I can't select them
all into memory, I can't use LIMIT, because it is slow at higher
values, so what is good to use ?

I am working on a DBD backend for SWI-Prolog
(http://www.swi-prolog.org). As it runs on top of my module
Language::Prolog::Yaswi, I have called it DBD::Yaswi and I would
like to register it and the "yaswi_" prefix on the DBI module.