Oracle's IAS globalization guide is pretty helpful in understanding the
interplay of Oracle, Perl and the web environment:
http://www.oracle.com/technology/tech/globalization/pdf/globalization-best-practices.PDF
It was written for 9i, but most of it still applies to 10g, I believe.
- Philip
Loo, Peter # PHX wrote:
Hi,
I am trying to execute two SQL statements within one call to
$dbh-do() and Perl DBI is not happy.
Here is a sample call:
$sql = qq{delete from some_table
where condition_one
andcondition_two;
insert into some_table
Robert Hicks wrote:
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Does anyone have such a beast for Oracle? I am trying to eliminate
the Perl/DBD::Oracle side of the equation for some problems in our
app. I did a looping select 20,000 times and the same for an insert.
I
Robert Hicks wrote:
Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select 20,000 times and the same for an insert.
I thought that someone might have a better script...
Have you tried
Craig Metzer wrote:
I'm getting an error trying to run an insert action due to the DATE or
DATETIME datatype. I couldn't find anything on it, and was wondering
if anyone could point me in the right direction -- Thanks
I'm trying to run an insert ... the date value is giving me errors.
Samuel_Zheng wrote:
Hi,
I am using activeperl 5.8.8 and DBI 1.58. If I want to use DBI to
work with a legacy clipper application, meaning to update the index
files, so the clipper application can continue to work. what module
is available out there? Anyone has some success stories to share
Martin J. Evans wrote:
Garrett, Philip (MAN-Corporate) wrote:
Martin Evans wrote:
Hoping someone can help me here as I'm really stuck with this. I
have a large amount of code which reads some XML and inserts data
from the XML into a database. One particular insert fails:
[snip
Hi Martin,
Martin Evans wrote:
Hoping someone can help me here as I'm really stuck with this. I have
a large amount of code which reads some XML and inserts data from the
XML into a database. One particular insert fails:
[snip]
After much head scratching I discovered the problem P4 has utf8
Martin Evans wrote:
Hoping someone can help me here as I'm really stuck with this. I
have a large amount of code which reads some XML and inserts data
from the XML into a database. One particular insert fails:
[snip]
After much head scratching I discovered the problem P4 has utf8 set
on it
This looks like a bug in your C compiler. I'd recommend making sure
your xlC (or VisualAge C or whatever) is fully patched.
-Original Message-
From: Floyd Wellershaus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 03, 2007 7:31 AM
To: dbi-users@perl.org
Subject: help compiling error on
[EMAIL PROTECTED] wrote:
Good morning,
I was given some tables on an Oracle database, but unfortunately I do
not know the field/column names of the table. I've made numerous
attempts to print such a list for a given table, but they never seem
to work. I've been trying SQL queries such as:
The account that is locked is the Oracle account, not the Unix account.
It is probably trying to use the default Oracle account scott/tiger,
unless you set ORACLE_USERID environment variable differently. Read the
README file for instructions on how to change the Oracle credentials for
testing.
-
Ben Edwards wrote:
I am trying to set up DBI Oracle stuff on a couple of boxes. One is
Ubuntu Feiesty and the other is running SunOS 5.8.
I have been using the following test script.
#!/usr/bin/perl
use DBI;
$dbh = DBI-connect( dbi:Oracle:gen3, user, pass );
Linux
---
I get:
Santosh Pathak wrote:
Hi,
I read on following site that DBD::CSV supports multi-character
separator. But I am not able to use it. my separator is |++|
http://www.annocpan.org/~JZUCKER/DBD-CSV-0.22/lib/DBD/CSV.pmhttp://www.
annocpan.org/%7EJZUCKER/DBD-CSV-0.22/lib/DBD/CSV.pm
Even after
Garrett, Philip (MAN-Corporate) wrote:
Santosh Pathak wrote:
Hi,
I read on following site that DBD::CSV supports multi-character
separator. But I am not able to use it. my separator is |++|
http://www.annocpan.org/~JZUCKER/DBD-CSV-0.22/lib/DBD/CSV.pmhttp://www.
annocpan.org/%7EJZUCKER
Robert Denton wrote:
These look like some great options and I will keep them in mind for
future projects, especially DBI::Gofer. In this instance, however,
the server I am working with is production frozen so to speak and I
cannot install anything on it at all. All I can do is ask it for
[EMAIL PROTECTED] wrote:
Anyone knows if DBD::Oracle has a function similar to the function
$sth-rows that exist in DBD::Mysql?
This is a DBI feature. It exists for all drivers.
This function give us the number o rows in a select command. So, we
don´t have to run a fetchrow with a while
John Scoles wrote:
Oracle doesn't have this feature so DBD::Oracle doesn't either.
This has cropped up many times before So you can blame Oracle on that.
Thier logic (as it was explained to me) is
How could you get the number of rows you are going to fetch without
counting them all first?
WoodShop wrote:
I currently have script/program that simply takes input lines and does
work on them. updating tables accordingly and all is good. however
every 'x' input lines i need to call a subroutine that does some work
on the database that takes a while, like 1 or 2 min. however i can't
joe bayer wrote:
I just upgrade my Oracle to 10g to a new Oracle HOME. How could I
change the pointer of DBI and DBD::oracle to this new home before I
remove the old home?
You will need to rebuild DBD::Oracle against your new 10g Oracle
installation. Download DBD::Oracle from CPAN and follow
Hi John,
[EMAIL PROTECTED] wrote:
I'm getting the error below when trying to install DBI 1.54. Linux is:
Red Hat Enterprise Linux ES release 3 (Taroon Update 5) or Red Hat
Enterprise Linux ES release 2.1 (Panama) ie both error. I don't get
the errors on my slackware box.
Hi George,
George Bills wrote:
Sorry if I'm asking a silly question - I'm very inexperienced with
databases. I'm playing around with using DBI / SQLite as a back-end
for parsing and storing log files - I have multiple columns like log
date, logged by, etc. I parse these in a Perl script, and
Sanjay Tripathi wrote:
I am using SunOS and Oracle as a DB.
To Install DBI I'm using below command
perl -MCPAN -e 'install Bundle::DBI'
[snip]
CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz
***
Perl versions below 5.6.1
Sanjay Tripathi wrote:
Please find the Logs for both of Perl Command as an attachment as per
your request.
Welcome to Dependency Hell. Here is your problem:
Writing Makefile for List::Util
-- NOT OK
Running make test
Can't test without successful make
Running make install
make
Sanjay Tripathi wrote:
Writing Makefile for List::Util
make: not found
INSTALL FAILED!
You need to install make. You'll also need a C compiler if you don't
already have it installed (which you probably don't).
- Philip
Matthew Ramadanovic wrote:
Why not just do something like this:
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print Couldn't use DBI : [EMAIL PROTECTED];
} else {
print Loaded DBI successfully\n;
}
Output:
Can't locate DBI.pm in @INC ...
Although this does indeed tell me that DBI is
Sanjay Tripathi wrote:
I am using SunOS and Oracle as a DB.
To Install DBI I'm using below command
perl -MCPAN -e 'install Bundle::DBI'
[snip]
CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz
Perl
Kimberly Mount wrote:
Can someone please help me out? I've asked a couple of times and
haven't had any success. Can you please remove me from this list? I
don't know what else to do?
Unsubscribe: Send an empty email to [EMAIL PROTECTED]
Cc: list, maybe somebody else will find this useful.
Hi Joseph,
Arokia Samy Joseph wrote:
The existing Perl, gcc versions we have in our system, are listed
below. Pls. let us know the steps to reinstall DBD::Oracle .
1) Download
http://www.cpan.org/modules/by-module/DBD/DBD-Oracle-1.19.tar.gz.
2) Unpack it
3) Read the README file very carefully
This works on my (admittedly ancient) DBD::SQLite v1.11.
However, if you're running version 2, this looks like it might be a bug
in DBD::SQLite, based on the first section of 5.0 Examples here:
http://www.sqlite.org/datatypes.html.
It might be helpful to submit a defect on rt.cpan.org per the
Arokia Samy Joseph wrote:
Hi,
We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0 After
the update we tried to execute a .pl code. The following error is
listed. Your suggestion / solution is much appreciated . Thanks!
ld.so.1: perl: fatal: libclntsh.so.8.0:
April Blumenstiel wrote:
Hello,
I have downloaded the instant client and the header files for Oracle
10g, and DBD::Oracle is compiling without error, but the make tests
are failing. The TNS is failing to resolve. I have set my TNS_ADMIN
var to the location of the file. I know it's a good
Have you set TWO_TASK or ORACLE_SID? What's the exact error you're
getting from the test suite?
From: April Blumenstiel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 05, 2007 3:37 PM
To: Garrett, Philip (MAN-Corporate); dbi-users
It looks like you're calling commit() on the $sth instead of the $dbh.
Philip
Andrew Edson wrote:
I am working with a perl file intended to enter a postgresql database
(as user postgres), select a list of key values based on one of those
values and delete any records which match the returned
Hi Bob,
- Forwarded message from Bob Hunter [EMAIL PROTECTED]
-
Date: Tue, 27 Feb 2007 08:03:19 -0800 (PST)
From: Bob Hunter [EMAIL PROTECTED]
Subject: DBI's method for reading [row x,field y]
Tim,
I am porting an application from Pg to DBI, and make extensive use of
the
-Original Message-
From: Bob Hunter [mailto:[EMAIL PROTECTED]
Sent: Tue 2/27/2007 5:07 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Subject: RE: (Fwd) DBI's method for reading [row x,field y]
The same example, using Pg...
# use Pg;
# my $dbh
William R. Mussatto wrote:
On Thu, February 22, 2007 15:35, Garrett, Philip \(MAN-Corporate\)
said:
Unless you plan to use DBI and threads in the same process, you can
ignore that test.
What is the impact of mod_apache if you are using threaded apache
server (vs. child spawning).
I'm
Tim Bunce wrote:
On Thu, Feb 22, 2007 at 09:12:14AM +, Martin Evans wrote:
Tim Bunce wrote:
On Wed, Feb 21, 2007 at 04:25:54PM +, Martin J. Evans wrote:
and I still get
Deep recursion on subroutine DBD::Oracle::db::dbms_output_get
dbms_output_get does create a new
Unless you plan to use DBI and threads in the same process, you can
ignore that test.
-Original Message-
From: Mike Southworth [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 12:23 AM
To: dbi-users@perl.org
Subject: DBI 1.53 Compile Does not Pass Test on RHEL 3.0
I have
To: Garrett, Philip (MAN-Corporate)
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
Philip
I Have downloaded the DBD::Oracle 1.15 from the link u have given and
copied to my local machine.
Should I compile it first in my local machine and then kept it in the
remote
Hi,
RaviChandra Chelikam wrote:
perl: fatal:
/usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:
Permission denied at .
^
The permissions on your Oracle installation are not letting Perl load
the Oracle client library. The library file libclntsh.so.9.0 (or
: Tuesday, February 20, 2007 1:23 PM
To: Garrett, Philip (MAN-Corporate)
Cc: dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to
oracle 10.2.0.2
Philip
We have Changed the permissions .
Even after
I ran this against v1.19 and had the same limit.
-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 8:25 PM
To: Garrett, Philip (MAN-Corporate)
Cc: Reidy, Ron; dbi-users@perl.org
Subject: Re: :Oracle - Any advance on inserting CLOB
Krishnan, Vijaya wrote:
Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an
upgrade to perl 6 would be required.
They're compatible. I'd recommend using the latest stable version of
Perl, though -- 5.8.8.
(Perl 6 is not released yet...)
Philip
I can confirm I have the same problems as Paul when inserting large
XMLType.
Running on:
1. SUSE LINUX Enterprise Server 9 (i586)
2. DBI v1.50
3. DBD::Oracle v1.18
4. Oracle client: 9.2.0.4.0
5. Oracle server: 9.2.0.7.0 - 64bit
Regards,
Philip
Paul Gallagher wrote:
Thanks for the info
(dbi:ADO:$dsn, $uname, $pword) or die
$DBI::errstr;
Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED] wrote:
Patrix Diradja wrote:
Yeah, that's the problem Garrett.
I usually use that way to connect to ms msql.
But now, I want that my perl code can work with several databases.
So I
Patrix Diradja wrote:
Dear my friends,
I wonder why my perl can not execute query use $database.
Sorry, I don't know for sure, but my guess is that the use database
command is a *client* command, and not valid SQL.
Generally speaking, when you want to connect to a specific database, it
Hi,
From: Goverdhan Reddy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 3:00 PM
To: dbi-users@perl.org
Subject: Errors in DBI installation!!
I am getting the errors when trying to install DBI module. Please have
a look at the attached files and let me know where I am going
Patrix Diradja wrote:
Dear my friend, Garret.
I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO.
I create 'myperl' as DSN from ODBC Administration Tools.
Here is my connection string:
my $dbh1 =
DBI-connect(dbi:ADO:database=gua;host=127.0.0.1;port=1433,
$uname,
Patrix Diradja wrote:
Yeah, that's the problem Garrett.
I usually use that way to connect to ms msql.
But now, I want that my perl code can work with several databases.
So I need somewhat like the Connection String which I can modify
(forming string) and than just does
Hi David,
You can ignore that error. It is just testing that the array execute
feature generates the expected warning. Since the test is written
against a 9i database, it could be that 10g just doesn't produce that
warning.
List: has anybody else had this problem installing against 10g? I
Terry Maragakis wrote:
I just installed DBI and Oracle DBD.
Did you also *just* install the Oracle client? Are you able to run
sqlplus
without problems?
Try this with your own user ID:
sqlplus scott/[EMAIL PROTECTED]
I can run the following program without error as root:
#!/bin/perl -w
The easiest way to know is to try it out. If you want to just test it
without replacing your installation's DBD::Oracle, you can do a
temporary install of a newer version of DBD::Oracle by using the
INSTALLSITELIB parameter to Makefile.PL:
wget
Malka Cymbalista wrote:
[snip]
I connect in the following manner:
DBI-connect(DBI:Oracle:asdb,user1,password1);
and
DBI-connect(DBI:Oracle:asdb2,user2,password2);
I have a script that works from the command line but does not work
when I run it from the web. When I run from the web it
Rohit V. Bhute wrote:
Does anyone know how I can connect via the web to 2 different oracle
databases sitting on 2 different machines from within the same
script.
If its Perl CGI and Apache, have you added the following to your
httpd.conf?
SetEnv ORACLE_HOME path to your Oracle setup
The
Malka Cymbalista wrote:
I am running Apache 2.0.55 with mod_perl 2.0.1 and Perl 5.8.1 on a Sun
Solaris machine. I am using DBI/DBD to connect to an Oracle database.
I am running DBI 1.39 and DBD-Oracle 1.16.
In order to connect to an oracle database on a different machine I
have a
Steve Canfield wrote:
the same compiler that was used...
[snip]
The entirety of the output of perl Makefile.PL,
make, and perl -V are echoed below. However, I
believe the problem lies in this error and others like
it:
/usr/lib/perl/5.8/CORE/perl.h:382:24: error:
sys/types.h:
Kevin Spencer wrote:
Hi guys,
I'm sure I'm missing something *very* obvious but this one has me
scratching my head. Using DBI 1.52, DBD::mysql 3.0007, Perl 5.8.8,
MySQL 5.0.18.
[snip]
my $SQL = EOSQL;
select count(*) from ?
where TRXSTATUS = ?
and (UNIX_TIMESTAMP() -
Chris Drake wrote:
I'm expanding, and adding extra web servers to handle my load. My
Apache/mod_perl environment maintains a new connection for each
process, and these processes seem to chew up a lot of server
resources.
What is the normal acceptable way to maintain large numbers of
Hi,
Chris wrote:
How about trying to create a brand new database using UTF8 *instead*
of AL32UTF8 ?
Oracle's UTF8 char set is old and incomplete. AL32UTF8 is the newer,
more complete version.
See http://tinyurl.com/y4qjd9 (oracle.com).
Oracle recommends that you switch to AL32UTF8 for full
FWIW, I tested a simple SELECT ? with your '[EMAIL PROTECTED]'
value against my Postgres 7.2 (DBD::Pg 1.21). It bound fine and
returned the correct value.
David Wu wrote:
Hi Brian,
Thanks for the suggestion. I thought that might be the case as well,
and I've already tried adding the type
Jonathan Leffler wrote:
On 11/8/06, Bart Lateur [EMAIL PROTECTED] wrote:
[snip]
1) What's the best way to temporarily disable RaiseError when I want
to have it enabled for the rest of the script? Say, for one SQL
statement?
$sth-{RaiseError} = 0;
Or:
$dbh-{RaiseError} = 0;
Sumitra Gatade wrote:
Hi,
I am trying to execute the stored procedure using dbh. The procedure
details are as follows:
proc_dequeue( BALID,strRequestXML,strStatus)
where:
BALID - Integer,
strRequestXML - XMLType,
strStatus - varchar
The perl script implemented is :
my $sth =
Robert Hicks wrote:
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the
Oracle handle to do inserts (i.e. Access - Oracle migration).
Only gotcha
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access - Oracle migration).
Only gotcha is with formatting -- you'll need to either:
1) alter session set
[EMAIL PROTECTED] wrote:
Hi Tim,
I have spent about three hours using Google and Metalink trying to
find the
answer to what must be a FAQ when generating XML from Oracle but I
cannot find anything that answers the question.
I work for a company in the UK and we are generating an XML
[EMAIL PROTECTED] wrote:
Hello All
Is it possible to pass an array as a parameter into an Oracle Stored
procedure. I am using Oracle 1.18a.
I have looked all over the place and have not found anything that
states that this is possible. If so - does anyone have an example?
Unfortunately,
Henrik Nilsson wrote:
What Perl binary hash file? I was referring to the contents of the
database (tables, procedures, constraints, etc). If you have a binary
object stored in the dB, export/import won't make it portable.
No, this was no Oracle database matter but a Perl hash file (which I
You can also use DBD::ODBC or DBD::ADO to go through the Windows odbc layer to
get to Oracle. It isn't as fully featured as DBD::Oracle, but it works.
From: Hameed Shahul-E4007Z [mailto:[EMAIL PROTECTED]
Sent: Thu 9/14/2006 1:56 AM
To: dbi-users@perl.org
Owen wrote:
The code below creates a database, then reads it but it fails when I
try to match an apostrophied name.
Any suggestions as to where I am going wrong would be much
appreciated.
$SQL = select * FROM tennisclub where last LIKE '%$name%' ;
$cursor = $dbh-prepare($SQL);
John Scoles wrote:
t/26exe_array...DBD::Oracle::st execute_array warning:
ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error
possibly near * indicator at char 66 in 'INSERT INTO
dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (:p1,:*p2,:p3)')
[for Statement INSERT INTO
Tim Bunce wrote:
It would be simpler to
$h-{PrintWarn} = 0;
at the right spot. (Perhaps in a block and using local.)
Hi Tim,
Yeah, that would be simpler (and it's what I do in my own code), but my
impression was that John wanted to leave the warning in there to test
that it would be
Loo, Peter # PHX wrote:
Hi,
Can someone please tell me what the size is when I set it to 1000? Is
it one meg?
It's $your_query_row_size * 1000. It's not a byte size, it's a number
of rows.
Regards,
Philip
Loo, Peter # PHX wrote:
RowCacheSize (integer)
What would you recommend I set this option to if I am sending all the
SELECTed rows to a named pipe?
I'd recommend you leave it alone, unless your database roundtrips are
really expensive. And if they are, the only thing that can tell you
I would expect a C program to be able to write to a file faster than any
database loader could load data.
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Thu 8/31/2006 5:49 PM
To: Garrett, Philip (MAN-Corporate); DBI-Users
Subject: RE: $dbh-{RowCacheSize
ManKyu Han wrote:
Hi. Again.
I did benchmark using BerkeleyDB (Hash) module (random select) and
the number I got was around 10,000 / sec.
I also did similar benchmark using DBD::DBM (with BerkeleyDB Hash
support). But this time, the number was too low. (less than 200
/sec).
I moved
Stephen Carville wrote:
I'm not quite sure how to describe this problem.
When I make a call to an Oracle 10g database using DBI and SQLRelay
(for connection pooling) I seem to get results from the previous
SELECT.
What happens when you use DBI *without* SQLRelay?
Philip
Lam, Keith (MGS) wrote:
Hi DBI experts,
Could you please help me to resolve this Perl Oracle DBD problem.
I am using Oracle Client 10g, Perl 5.8.5 (default from RedHat ES4
installation) and Oracle-DBD-1.18.
The SQLPLUS and Perl cgi program runs and displays output as expected
without
Artem Harutyunyan wrote:
Hi,
Are you using a table type in mysql that supports transactions?
Well, I am not sure, how can I check it ?
mysql show table status like '%transaction%';
The second column (engine) is what you're interested in... needs to be
InnoDB to support transactions.
Angus McIntyre wrote:
I'm using current versions of DBI and DBD::Oracle in a CGI script,
Oracle
10.2 client talking to an Oracle 9 database, RedHat Linux. The script
previously ran successfully on a similar machine with the Oracle 9
client.
I have a simple test script, in which the
John Scoles wrote:
DBD::Oracle 1.18 has been released.
With this release DBD::Oracle finally implements Oracle's native
Array Interface. You will see very dramatic increase in speed. For
example; the time for a 2 million plus insert query dropped from well
over an hour to less than 10
Corey wrote:
Greetings!
I'm using DBI w/ DBD::Pg, and am in the midst of attempting to
simplify some existing code. I happened on the following older
perl.com article: http://www.perl.com/pub/a/2001/03/dbiokay.html
which provides what
seems to be a nicely concise way of constructing
Garrett, Philip (MAN-Corporate) wrote:
Corey wrote:
Greetings!
I'm using DBI w/ DBD::Pg, and am in the midst of attempting to
simplify some existing code. I happened on the following older
perl.com article: http://www.perl.com/pub/a/2001/03/dbiokay.html
which provides what seems
that the latest version
addresses this problem.
cc:ing the author to see if he has something to offer.
-Mohan
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 24, 2006 8:17 PM
To: Palisetti, Krishna_Mohan; dbi-users@perl.org
Palisetti, Krishna_Mohan wrote:
Hi, I'm seeing the following warning message from
DBIx::ContextualFetch intermittently. Use of uninitialized value in
null operation at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
51.
What does it mean? Sorry, I am not in a position
Palisetti, Krishna_Mohan wrote:
Hi, I'm seeing the following warning message from
DBIx::ContextualFetch intermittently. Use of uninitialized value
in null operation at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
51.
What does it mean? Sorry, I am not in a position to
perl version 5.8.5
lunux enterprise ES 4
DBD-Oracle-1.16
DBI-1.30
Thanks
--
Open WebMail Project (http://openwebmail.org)
-- Original Message ---
From: Tim Bunce [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
Sent: Wed, 19 Jul 2006 08:37:27 -0700
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses $drivers{$_}\n;
}
Nothing is returned. Yet if I use :
my @drivers = DBI-available_drivers();
LI Yi wrote:
I'm trying to install v2.15 on cygwin
tar zxvf Template-Toolkit-2.15.tar.gz
cd Template-Toolkit-2.15
perl Makefile.PL
make
make test
make install
I get
Can't locate AppConfig.pm in @INC (@INC contains: blib/lib blib/arch
[EMAIL PROTECTED] wrote:
Guys,
Can anyone answer following questions please
1) Do I have to install sqlplus to connect to Oracle database from
Perl
No, but it typically comes with the files that you DO need (the Oracle
client). Google oracle instantclient
2) What , how and where can I
cheryl fillekes wrote:
Tim,
In the most excellent
http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Oracle_and_Unicode
there is reference to the oracle internationalization documentation.
Do you have a more specific reference for that, particularly as
relates to 9i? A link would be great
Loo, Peter # PHX wrote:
Hi All,
I need to issue commands such as (CREATE TABLE, DROP TABLE,
ALTER TABLE, etc...), however, whenever I use sth-do($sqlString),
I get an error. I understand that using sth-do(), it goes through
the process of prepare and execute. With that, it is expecting a
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 5:26 AM
To: dbi-users@perl.org
Subject: DBD:CSV problem on Solaris
Hello,
I do have a problem with a littler perl script I wrote.
It uses DBD:CSV and I don´t know why it doesn´t
-Original Message-
From: Lihong Sun [mailto:[EMAIL PROTECTED]
Sent: Monday, June 26, 2006 2:49 PM
To: dbi-users@perl.org
Subject: dbi-users@perl.org
Dear folks,
I have a question for you here. I just installed DBI and Oracle DBD
module. I tried a test script but got the following
-Original Message-
From: Todd Chisholm
Sent: Thursday, June 22, 2006 1:54 PM
Subject: Getting spatial data?
my $query = select geometry from processed_product where id=15601;
my $sth = $connect-prepare($query);
$sth-execute();
[snip]
DBD::Oracle::db prepare failed: ERROR
'die' on every statement.
-Will
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Thursday 22 June 2006 14:08
To: dbi-users@perl.org
Subject: RE: Getting spatial data?
Just nit picking here, but don't forget || die $connect-errstr
after your
-Original Message-
From: Tyler MacDonald [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 2:54 PM
To: Kandi, Santosh
Cc: dbi-users@perl.org
Subject: Re: Non-Standard Installation
Kandi, Santosh [EMAIL PROTECTED] wrote:
I thought that since DBI.pm and DBD (Oracle.pm) are
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Monday, June 12, 2006 9:22 PM
To: List - DBI users
Subject: Speed test for connecting to Oracle for Windows via ODBC
Hi Folks
Using a DSN of dbi:ODBC:xyz, the DBI - connect(...) call takes 16
(sic) seconds with
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 13, 2006 6:11 PM
To: List - DBI users
Subject: RE: Speed test for connecting to Oracle for Windows via ODBC
On Tue, 13 Jun 2006 09:57:38 -0400, Garrett, Philip \(MAN-Corporate\)
wrote:
- Test
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 31, 2006 12:02 PM
To: R, Rajsekar
Cc: dbi-users@perl.org
Subject: Re: perl- dbi
On 5/31/06, R, Rajsekar [EMAIL PROTECTED] wrote:
how do i ensure that DBI is installed in my machine..
will it
1 - 100 of 129 matches
Mail list logo
