Hi list.
I believe I have tripped a DBD::Oracle bug in the way it binds utf8
parameters. If I create a statement and execute it with a non-utf8
parameter, it works. If I then execute that *same sth* with a utf8
parameter (scalar with UTF8 flag on), I receive the following error:
ORA-01460:
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 03, 2006 1:50 PM
To: dbi-users@perl.org
Subject: DBD::Oracle error when switching between utf8 and non-utf8
[snip]
DBI: 1.4.1
Probably obvious, but I meant 1.41.
Philip
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 8:54 AM
To: dbi-users@perl.org
Subject: Re: DBD::Oracle error when switching between utf8 and
non-utf8
Just ran the same test in the windows environment and the test did
fail as follows
[Dbi-dev is for driver maintainers, not for general support questions.
I reposted to dbi-users.]
-Original Message-
From: Paul G. Weiss [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:47 AM
To: dbi-dev@perl.org
Subject: Binding undefs in DBD::Oracle
I always that the
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:29 AM
To: dbi-users@perl.org
Subject: Re: DBD::Oracle error when switching between utf8 and
non-utf8
Well find a few things
The windows error comes from the fact that I did not have
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 7:13 AM
To: dbi-users@perl.org
Subject: DBD::ODBC in a web application
If I create a test script to connect to a Microsoft Access database
that is on a network (UNC) drive I can connect
What database are you using? Perhaps the driver has an option to do this. I
know Oracle does.
-Original Message-
From: Mark Hedges [mailto:[EMAIL PROTECTED]
Sent: Tue 3/28/2006 9:39 PM
To: dbi-users@perl.org
Subject: forcing utf8 on selected values
There are several to-do items
-Original Message-
From: Rhugga Harper [mailto:[EMAIL PROTECTED]
Sent: Monday, April 03, 2006 10:39 AM
To: Jonathan Leffler
Cc: dbi-users@perl.org
Subject: Re: Problem on Solaris 8 64-bit.
On 3/30/06, Jonathan Leffler [EMAIL PROTECTED] wrote:
On 3/30/06, Rhugga Harper
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 10:37 AM
To: dbi-users@perl.org
Subject: Not exactly a dbi question
Hi all,
I hope someone here can help me.
The DBD::mysql docs seem to say that mysql_affected_rows is still a
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 10:52 AM
To: dbi-users@perl.org
Subject: RE: Not exactly a dbi question
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 3:14 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
The execute() method returns the number of rows affected for DML
(insert
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 3:14 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
The execute() method returns the number of rows affected
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 4:20 PM
To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06 15:06, Jonathan Mangin [EMAIL PROTECTED] wrote
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 2:55 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:41 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
[snip]
Sorry, I've been answering your question while assuming the mysql
driver
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:56 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/5/06 9:46, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote
No, DBD::Oracle requires the Oracle client libraries to be installed.
There are other options, though, depending on your requirements:
* DBD::Proxy - requires another system that DOES have DBD::Oracle (or,
you could proxy through a Windows server that has an ADO driver for
Oracle)
*
-Original Message-
From: Aleksander Adamowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 18, 2006 4:39 AM
To: dbi-users@perl.org
Subject: Semantics of InactiveDestroy
Hi!
I have a problem with parsing the documentation regarding the
InactiveDestroy attribute on DB handles.
-Original Message-
From: Dr.Ruud [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 6:37 AM
To: dbi-users@perl.org
Subject: Re: last insert id
[snip]
I did not say it extracts the colons, and I did not say it returns
the
connect string with the embedded colons, and I did
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 10:38 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: RE: last insert id
Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED]
wrote:
Whatever anchors
-
From: Kevin Moore [mailto:[EMAIL PROTECTED]
Sent: Sun 4/23/2006 12:15 AM
To: dbi-users@perl.org
Subject: DBD module loading problem
Objective - execute perl modules from apache that access an oracle
database
Oracle
-Original Message-
From: Sagiv Barhoom [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 11:28 AM
To: dbi-users@perl.org
Subject: problems getting Hebrew strings from Oracle
Hi all,
I have 2 machines: linux_perl_machine and sql_server (Oracle 9i).
I am trying to connect from
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 2:15 PM
To: DBI users
Subject: DBI-data_sources('Oracle')
Hi All,
Will someone please tell me where this module is getting the
information from? One of my severs that I am trying
-Original Message-
From: Cole, Ben [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 09, 2006 10:45 AM
To: dbi-users@perl.org
Subject: DBD-Oracle.ppd
Hello,
I have been desperately searching for a 5.8.* DBD-Oracle.ppd for quite
some time now. The machine on which I need to install it
-Original Message-
From: Mark Galbreath [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 9:11 AM
To: dbi-users@perl.org
Subject: DBD::XBase, STDOUT, and IO issue
Hi Guys,
I'm using a subclass of DBI called DBD::XBase for reading Oralce DBF
tablespace datafiles, translating
-Original Message-
From: Dr.Ruud [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 11:08 AM
To: dbi-users@perl.org
Subject: Re: :XBase, STDOUT, and IO issue
Garrett, Philip:
Mark Galbreath:
I searched all night and cannot find an example of how to do this
correctly.
-Original Message-
From: louis gonzales [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 2:36 PM
To: pgsql-admin@postgresql.org; dbi-users@perl.org
Subject: install_driver(Pg) failed: Can't load Pg.so
OS = Solaris 9
PERL v = 5.8.7
postgreSQL = 8.0.1
I'm getting the following
-Original Message-
From: louis gonzales [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 2:52 PM
To: Garrett, Philip (MAN-Corporate)
Cc: dbi-users@perl.org
Subject: Re: install_driver(Pg) failed: Can't load Pg.so
Garrett, Philip (MAN-Corporate) wrote:
From: louis gonzales
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 2:40 PM
To: DBI-Users
Subject: how to invoke .sql file from dbi
Hello all,
We have bunch of sql files ( .sql ) that we want to invoke from dbi (
Oracle ). How does it work. Dbi expects
-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
-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: 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: 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: 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: [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
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
[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
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
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();
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
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
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
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
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
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
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.
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
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
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
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
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);
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
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
[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,
[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
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
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
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 =
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;
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
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
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() -
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
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
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
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
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
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
(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
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
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 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
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
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
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
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
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
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
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
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:
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
1 - 100 of 129 matches
Mail list logo