I am looking at a release-critical bug which means that the
libdbd-ram-perl Debian package fails to build on sid/unstable, see
this page for details:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=264670
The error occurs in the DBD::RAM (version 0.072) test routine (test.pl):
Testing empty
Tim Bunce wrote:
A mature, and hopefully final, release candidate of DBD::Oracle 1.16
is available for testing at:
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz
Perl 5.6.1, WinNT, Borland 5.5,
Oracle Client 8.1.7.4.15,
Oracle Server 9.2.0.4.0
Tim Bunce wrote:
A mature, and hopefully final, release candidate of DBD::Oracle 1.16
is available for testing at:
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz
Perl 5.6.1, WinNT, Borland 5.5,
Oracle Client 8.1.7.4.15,
Oracle Server 9.2.0.4.0
Hello Tim,
I am using:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
This is perl, v5.8.1 built for MSWin32-x86-multi-thread
and the release candidate seems to be working at first glance.
But I get this:
t\31lob.ok
t\40ph_type.ok 7/19 Placeholder
On Mon, Aug 09, 2004 at 11:01:12PM -0400, Rudy Lippan wrote:
On Sat, 7 Aug 2004, Patrick Galbraith wrote:
As far as use_result vs. store result, the server prepared statements
(mysql 4.1 and greater) will always use 'store result', as this has no
affect on performance as per the API
Hello,
I am not sure if this is a bug but I have used DBI and DBD::Oracle
for a long time without any probllem and I am almost certain that
something might be wrong. Both modules are awesome and this is the
first time that I have ever seen any unexpected behavior. The issue:
1) if I set
Hi,
I would like to know if there is a better way to fetch an entire table
to a file (the file has to be tab delimited) instead of using
fetchrow_array function? Fetchrow_array is working fine but slow to
work with a big table.
Thanks,
Adam.
Hey all,
For those of you who have tried the new DBD::Sybase, announced on 4 Aug, would you
consider it production quality?
I'm currently using 1.02, but am having problems with it hanging against an 11.9.2
server when doing massive non-bulk inserts (50,000+ rows). I figured before I do
Is there a way to dereference the SQL statement that is send to the DBD?
I am loading a master table with 19+ fields and there seem to be a problem
at the end of the SQL statement. I want to see what is the DBI/DBD sending
to the Database.
example:
$q3 = $dbh-prepare(INSERT INTO
Posting this here so that others can find the information if necessary.
Recent versions of ASE on MacOSX have changed the name of the Sybase
libs from libct, libcs, etc. to libsybct, libsybcs, etc.
DBD::Sybase 1.04 and later detect this change.
Some versions of ASE on MacOSX don't include the
I'm calling some stored procedures using DBI 1.32, DBD::ODBC 1.07 and
Perl v5.8.0 (ActivePerl build 805) running on Win2kServer SP4 using
MS SQL 2000.
Am I supposed to initialize the variables I pass to
bind_param_inout()?
I'm using code like this to prepare and call the stored procedures
Did you install Oracle properly (i.e. from the CDs or from a
download from technet)? Did you read README.clients as suggested?
I installed it from CDs I get from Oracle for linux and the install went smooth.
I am able to connect to a remote db via sqlplus..etc.
I used the oracle install
Test...
--
`\|||/ amonotod@| sun|perl|windows
(@@) charter.net | sysadmin|dba
ooO_(_)_Ooo
_|_|_|_|_|_|_|_|
On Wed, 11 Aug 2004 11:34:00 -0500
Xinyu Wen [EMAIL PROTECTED] wrote:
Hi,
I would like to know if there is a better way to fetch an entire table
to a file (the file has to be tab delimited) instead of using
fetchrow_array function? Fetchrow_array is working fine but slow to
work with a
On Wed, 2004-08-11 at 19:39, amonotod wrote:
Hey all,
For those of you who have tried the new DBD::Sybase, announced on 4
Aug, would you consider it production quality?
Yes, apart from the BLK stuff.
I'm currently using 1.02, but am having problems with it hanging
against an 11.9.2
On Mon, Aug 09, 2004 at 07:02:20PM +0200, mAsterdam wrote:
Tim Bunce wrote:
mAsterdam wrote:
Oracle 8.1.7 ...
Can you send me the output (stdout+stderr) from perl -Mblib t/foo.t
where foo is each of the tests that generated that error?
(Then the same again but with DBI_TRACE=9 would also
Hey Anyone had a problem installing
the DBD::Oracle module on a 64bit version of oracle 9?
I keep getting the following errors
Thanks
joe
On Sat, Aug 07, 2004 at 11:32:45PM +0100, Tim Bunce wrote:
A mature, and hopefully final, release candidate of DBD::Oracle 1.16
is available for testing at:
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz
Please help by taking a moment to at least check it builds
Not sure if this is what you're looking for, but do
perldoc DBI
at a command prompt and search for selectall_arrayref,
selectall_hashref, and
fetchall_arrayref.
Hardy Merrill
Xinyu Wen [EMAIL PROTECTED] 08/11/04 12:34PM
Hi,
I would like to know if there is a better way to fetch an
Use trace.
Here's the whole section from perldoc DBI about using trace:
trace
DBI-trace($trace_level)
DBI-trace($trace_level, $trace_filename)
DBI trace information can be enabled for all handles using the
trace DBI class method. To enable trace
test DBD::Oracle 1.16rc6 on HP-UX 10.20 and Oracle 8.0.6.0 (server and client the same
revision)
+ umask 022
+ export ORACLE_HOME=/opt/oracle/v806
+ export ORACLE_USERID=guest/guest
+ export TNS_ADMIN=/home/ddts/local
+ export TWO_TASK=dbtset806
+ make test
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp
test DBD::Oracle 1.16rc6 on HP-UX 11.00 and Oracle 8.1.7.0 (server and client
the same revision) using perl 5.6.1
see attachments.
--
Silvio Wanka| e-mail: [EMAIL PROTECTED]
+ umask 022
+ export ORACLE_HOME=/opt/Oracle
+ export ORACLE_USERID=guest/guest
+ export TWO_TASK=dbtest817
+
Tim Bunce wrote:
mAsterdam wrote:
Tim Bunce wrote:
mAsterdam wrote:
Oracle 8.1.7 ...
Can you send me the output (stdout+stderr) from
perl -Mblib t/foo.t where foo is each of the tests
that generated that error? ...
@foo = ('23wide_db', '23wide_db_al32utf8');
set
Our DBA has recently upgraded Oracle from 8.1.7 to 9.2. I tried
changing my ORACLE_HOME enviornment and it broke my DBI/DBD::Oracle.
If I run
$ENV{ORACLE_HOME} = /opt/oracle/products/8.1.7;
$db = DBI-connect (dbi:Oracle:xxx, uname, pword,
{AutoCommit=0});
all is well
If I run
$ENV{ORACLE_HOME}
Reinstall DBD::Oracle using the 9i environment.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Richard Freedman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 5:53 PM
To: [EMAIL PROTECTED]
Subject: Oracle 9.2 upgrade breaks Perl DBI
Our
Did you recompile DBD::Oracle since Oracle 9.2 was installed?
Richard Freedman [EMAIL PROTECTED] 08/10/04 07:52PM
Our DBA has recently upgraded Oracle from 8.1.7 to 9.2. I tried
changing my ORACLE_HOME enviornment and it broke my DBI/DBD::Oracle.
If I run
$ENV{ORACLE_HOME} =
From: Tim Bunce [EMAIL PROTECTED]
Date: 2004/08/07 Sat PM 10:32:45 GMT
A mature, and hopefully final, release candidate of DBD::Oracle 1.16
snip
Please help by taking a moment to at least check it builds and tests okay
in your environment.
Thank you.
Tim.
Results of a failed build are
From: amonotod [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 04:01:54 GMT
Results of a failed build are below.
Or perhaps, not. Apparently, failed tests are not indicative of a
failed build. 'nmake install' went just fine, and my DBI scripts
work just fine against Oracle 8i and Oracle 9i
Need help in trying to insert an sql statement.
1) I have 15 columns in oracle database defined.
2) Through Perl DBI I am trying to loop and populate these 15
columns for 'n' of rows.
3) Some of the column values that I am trying to insert is
null/empty and it is ok if they
You have a NULL (not the word NULL) in your statement.
FYI - You should look into using bind variables.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 10:43 AM
To: [EMAIL
I tried to use different methods to insert but all fails.
1) $sth=$dbh-prepare(insert into OPER_QUERY values ($a,$b,$c,$d) )
$sth-execute() or die;
2) $sth=$dbh-prepare(insert into OPER_QUERY (col1, col2, col3..co15)
values($a,$b,$c,$d) )
$sth-execute() or die;
3)
From your original post ...
!! ERROR: 936 'ORA-00936: missing expression (DBD: error possibly
near * indicator at char 252 in 'insert into OPER_QUERY
(end_date,site,tester_type,program,total,oper_yes,rmenu_yes,opr_dev_type
Try the mothed 2 with non-numeric fields single-quoted.
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:07 PM
To: Reidy, Ron; [EMAIL PROTECTED]
Subject: RE: SQL- Insert problem
I tried to use different methods to insert but all fails.
1)
He should use bind variables (method 3).
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 11:13 AM
To: Shah, Urmil; Reidy, Ron; [EMAIL PROTECTED]
Subject: RE: SQL- Insert problem
Greetings DBI list,
I'm not certain this is the right place to send this but the tkishel AT
tdlc.com address contained within the DBD::Multiplex documentation is
bouncing mail.
Been running into problems with DBD::Multiplex (1.9) on perl, v5.8.3
built for i686-linux system.
Errors were:
Ok I tried to use method 3 and as I said it hangs. Since it's a dynamic
sql some variables are undefined and they do not have any value, now if
they don't have any value is it possible that DBI/Oracle will interpret
as empty values ? else I have to check the values of each variable and
then
Just in case the op doesn't make the connection, he needs to test his
variables for undef before the execute, and if one is undef, then put
null() in it, something like this:
if (!defined($a)) {$a = ;}
if (!defined($b)) {$b = ;}
... and so on - you get the idea...
From: Michael Peppler [EMAIL PROTECTED]
Date: 2004/08/13 Fri AM 07:50:56 GMT
On Wed, 2004-08-11 at 19:39, amonotod wrote:
I'm currently using 1.02, but am having problems with it hanging
against an 11.9.2 server when doing massive non-bulk inserts (50,000+
space defined, or trunc. log on
You need to ensure your variables have values. In the case where they are undef,
assigning them the empty string () should be sufficient.
If this statement still hangs when doing this, you need to run a 10046 trace for your
session to see what is going on (see your DBA for this).
Starting with Teradata V2R5.1 by default logons are encrypted. This broke the
venerable Teradata
DBD V 1.13. You can turn off the requirement for the encryption at the server, but
they tend to
look at you funny when you tell them you want to muck about on their big bucks server
because your
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote:
Just in case the op doesn't make the connection, he needs to test his
variables for undef before the execute, and if one is undef, then put
null() in it, something like this:
if (!defined($a)) {$a = ;}
if (!defined($b)) {$b = ;}
Douglas Marsh wrote:
Starting with Teradata V2R5.1 by default logons are encrypted. This broke the venerable Teradata
DBD V 1.13. You can turn off the requirement for the encryption at the server, but they tend to
look at you funny when you tell them you want to muck about on their big bucks
Jenda,
It could be a bug. Can you wrap up a quick test case and I'll trace it
through?
Regards,
Jeff
I'm calling some stored procedures using DBI 1.32, DBD::ODBC 1.07 and
Perl v5.8.0 (ActivePerl build 805) running on Win2kServer SP4 using
MS SQL 2000.
Am I supposed to initialize the
Ronald J Kimball [EMAIL PROTECTED] 08/13/04 01:59PM
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote:
Just in case the op doesn't make the connection, he needs to test
his
variables for undef before the execute, and if one is undef, then
put
null() in it, something like this:
if
I would highly recommend using the -w option (and 'use strict;' if you
are not already). I'd also recommend pulling the prepare out of the
loop - If you are using bind variables you shouldn't need to prepare
the statement every time through the loop.
The hanging behavior is odd. I (and
See below ...
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
303.386.1480
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:02 PM
To: Reidy, Ron; Kong, Alan; [EMAIL PROTECTED]
Subject: RE: SQL- Insert problem
Ok Here is
From: Shah, Urmil [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 04:42:54 GMT
Need help in trying to insert an sql statement.
As everyone else has been saying, you need to use placeholders.
See my script below... Note that I tested with MSSQL, but
Regards,
Urmil
Regards,
amonotod
#!perl
From: amonotod [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 07:29:35 GMT
Note that I tested with MSSQL, but
Well, yes, I did test with MSSQL, but as you can see from the DBI
connection string, I also tested with Oracle 9i...
:-)
amonotod
--
`\|||/ amonotod@|
Here is the code if it helps.
I do not know how to run trace 10046 but I
have put output from V$session_wait for my session.
my $dbh = $db-connect($graph_fab);
$sth1 = $dbh-prepare(qq{insert into
temp values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}) or dieCannot prepare
From: Shah, Urmil [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 07:48:44 GMT
$sth1 = $dbh-prepare(qq{insert into temp values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}) or
dieCannot prepare sql:$DBI::errstr\n;
My understanding was that placeholders must have column names associated
with them, so I dont'
See below ...
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
303.386.1480
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:49 PM
To: [EMAIL PROTECTED]
Subject: RE: SQL- Insert problem
Here is the code if it helps.
I
From: Ronald J Kimball [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 05:59:39 GMT
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote:
Just in case the op doesn't make the connection, he needs to test his
variables for undef before the execute, and if one is undef, then put
Why does he need
Correct, but he he building dynamic SQL. The resulting insert statement's values
clause looks like (v1,v1,,v4...); the problem is the ,,.
This is why I suggested to use bind variables.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: amonotod
Ron/Amonotod/Ronald/Merrill
Its working !!!
Thank you very much for all your time and extended help. It was my
mistake that I was unaware and caused this problem.
I had a perl script that would insert data into the table. Some columns
in this table had unique value constraint so I had to delete
From: amonotod [EMAIL PROTECTED]
Date: 2004/08/13 Fri PM 05:33:16 GMT
From: Michael Peppler [EMAIL PROTECTED]
Date: 2004/08/13 Fri AM 07:50:56 GMT
space defined, or trunc. log on checkpoint turned on?
Might you know how to control how often the checkpoints happen?
Okay, never
Tim Bunce wrote:
Does the binary protocol allow the link to be used for other actions while
there are still rows being sent to the client?
If not use result can't be the default as too much existing code would break.
My experementation would suggest that it doesn't - if you turn
use_result on
56 matches
Mail list logo
