http://groups.google.com/groups?group=perl.dbi.users
Should be fast enough for you :)
Tim.
On Fri, Sep 27, 2002 at 09:22:16AM -0500, Sumitro Chowdhury wrote:
Might as well ask this question here without being too-much out of topic:
What is the URL for a fast site hosting searchable
+
X-OriginalArrivalTime: 01 Oct 2002 03:44:27.0536 (UTC) FILETIME=[D7712900:01C268FC]
Tim Bunce
I get this following problem when I ran 'perl makefile.pl' from the
directory DBD-Oracle-1.12 where I unzipped the DBD-Oracle-1.12.tar.gz:
*Error message
On Mon, Sep 30, 2002 at 02:58:28PM -0700, Michael A Chase wrote:
On Mon, 30 Sep 2002 13:34:17 -0600 Sterin, Ilya [EMAIL PROTECTED] wrote:
In search for a volunteer to transfer the answers from the old FAQ, which
are not already in the new version and update the FAQ-O-Matic. If anyone is
Stack trace - from the core file. Not a DBI trace log.
Tim.
On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
Tim, Is there any thing I can provide that may help resolve this issue.
Now that I don't get perl dieing, would the DBI trace help ?
On Thu, 2002-09-26 at 10:11, Glen
On Mon, Sep 30, 2002 at 08:01:54PM -0400, Matthew O. Persico wrote:
On Mon, 30 Sep 2002 09:56:20 +0100, Tim Bunce spaketh:
On Sun, Sep 29, 2002 at 06:37:01PM -0400, Matthew O. Persico wrote:
[snippage]
Q: How do I share a database handle between a parent and its child
process? ???
You
On Mon, Sep 30, 2002 at 06:27:38PM -0400, Sam Tregar wrote:
Hello all. I'm thinking about creating a DBI::Profile subclass to enable
profiling of database queries in large Apache/mod_perl applications.
Excellent. I was hoping someone would.
Here's my plan:
- At runtime, instead of
On Mon, Sep 30, 2002 at 06:24:52PM -0600, Sterin, Ilya wrote:
Forwarding to dbi-dev. This is where it belongs.
Actually for the initial discussion dbi-users is probably the best
place to explore what's needed. After that dbi-dev would be better
for the detailed design work.
Tim.
Sam:
On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
Tim, Is there any thing I can provide that may help resolve this issue.
Now that I don't get perl dieing, would the DBI trace help ?
Uh, wasn't paying attention. Sorry. Yes. trace(9), just to me, not the list.
Can't promise to
On Tue, Oct 01, 2002 at 04:17:51PM -0500, Jesse, Rich wrote:
Hi,
A Solaris system that I have little control over is running Perl 5.005_03,
and a DBI_TRACE level 2 shows DBI v1.13 and DBD::Oracle v1.03. The Oracle
client on the Solaris server is 8.0.5.0.0. The Oracle DB we're connecting
On Tue, Oct 01, 2002 at 05:03:04PM -0700, Michael A Chase wrote:
On Tue, 1 Oct 2002 14:41:53 -0700 Henri Asseily [EMAIL PROTECTED] wrote:
I have an $sth being passed to a function. I want to get access to its
$dbh, from within that function, but the $dbh isn't passed as a
parameter.
Make sure you're using the latest DBD::Oracle.
Send a trace(8) log - just the part from prepare thru execute.
Tim.
On Wed, Oct 02, 2002 at 05:45:01PM -0500, John-Thomas Beadles wrote:
Help! I'm having a severe performance problem with a Perl program talking
to a remote Oracle database. I've
Use trace()
Tim.
On Wed, Oct 02, 2002 at 04:16:21PM -0500, Bill Hamilton wrote:
I am using DBI on NT4 , Informix 7.24 on a Sun box.
The dbi driver is ADO.
I seem to have a bug someplace when an aggregate function is used with
fetchrow_array.
Consider...
$salessel = qq/SELECT
- Forwarded message from Vivek Kukrety [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Thu, 3 Oct 2002 23:13:16 -0700 (PDT)
From: Vivek Kukrety [EMAIL PROTECTED]
Subject: Problem with DBI
To: [EMAIL PROTECTED]
Hi Tim,
I have a problem with DBI on Windows. I am attaching a
On Thu, Oct 03, 2002 at 05:27:17PM -0400, Sam Tregar wrote:
On Tue, 1 Oct 2002, Tim Bunce wrote:
- Build the sub-class in such a way that it does not accumulate
profiling data in-memory without limit. Devel::DProf and
Devel::Profiler accomplish this by doing buffered writes
On Fri, Oct 04, 2002 at 10:49:14AM -0500, Bill Hamilton wrote:
Many thanks for you help.
I did as you suggested.
I wrote a smaller version of the program to cut it down to just these two
columns.
$oh_sel = qq/SELECT sum(s.qty_on_hand),sum(s.qty_committed) FROM bin_mat bm,
stock s
WHERE
On Sat, Oct 05, 2002 at 05:21:09PM -0600, Sterin, Ilya wrote:
Sorry for the inconvenience, all.
We thought it would be a good idea for the FAQ changes to go to the list,
but guess it was too much...
There's much more FAQ editing activity now then there will be in future.
Plus FAQ-o-matic
Thanks. I've already got that fixed up (thanks mostly to patches sent earlier).
The real problem is that I've not got round to making a release.
I will be trying to make a release within a week or so.
Tim.
On Thu, Oct 10, 2002 at 05:47:29PM -0500, Stephen Clouse wrote:
On Thu, Oct 10, 2002 at
The driver needs to support the (new) ParamValues attribute.
If it does then setting the ShowErrorStatement attribute will
include both the Statement text and the ParamValues in the error
message. Assuming you're using a recent DBI version.
Tim.
On Fri, Oct 11, 2002 at 02:35:18PM -0700, Naveen
On Fri, Oct 11, 2002 at 12:50:15PM -0700, Henri Asseily wrote:
This is somewhat OT, but I need an answer from within the DBI community:
I want to release a new DBIx module, DBIx::HA (for High Availability).
What will it do, and how?
In this module I need to do some work on shared memory
On Fri, Oct 11, 2002 at 05:01:39PM -0700, Henri Asseily wrote:
On Friday, October 11, 2002, at 02:39 PM, Tim Bunce wrote:
There hasn't been up to now (or at least I haven't found any) a widely
available Perl/DBI-based system for system architects who handle
high-availability groups
DBD::Oracle version .47 was released on 8th Sept 1997.
I think the bug affecting you was fixed in DBD::Oracle 1.02,
released three years ago.
Upgrade.
Tim.
On Fri, Oct 11, 2002 at 04:42:15PM -0700, Daniel Olson wrote:
I'm writing a CGI script in Perl to extract longs from an Oracle
database
You can't use DBI::PurePerl with a NON-pure-perl driver.
Tim.
On Mon, Oct 14, 2002 at 08:19:57AM +0200, Frederic Van de Velde wrote:
Hi,
I'm trying to run some perl (currently 5.00503) on AIX 4.3 to connect an
Oracle 8 database on the same system (DBD::Oracle is 1.06)
My problem is that
On Mon, Oct 14, 2002 at 10:42:10AM -0700, Kevin Scaldeferri wrote:
Tim Vorce wrote:
It is my impression that the utf flag isn't set unless you explicitly set
it. That seems to impact program stuff rather than data, and that may
best be set by the statement
use utf8;
In Perl 5.8, 'use
Upgrade and read the docs.
Tim.
On Mon, Oct 14, 2002 at 03:23:42PM -0700, Philip Daggett wrote:
I'm downloading several million records from an Oracle database to a MySql
database and would like to use fetchall_arrayref() to do it. However, there
are so many records that my computer memory
On Tue, Oct 15, 2002 at 11:44:54AM -0700, Hastie, Christa wrote:
Hello!
I bet there is some really simple DBI function/reg ex that delimits the
apostrophes like such (\') so data can be inserted into the db without
errors.
i.e. this string:
INSERT INTO db (SomeColumn) VALUES ('John's car
the perldoc command
installed so you can read the DBI docs by running perldoc DBI.
No need to use the web.
Tim.
Thanks!
- christa
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 12:53 PM
To: Hastie, Christa
Cc: '[EMAIL PROTECTED]'
Subject
On Tue, Oct 15, 2002 at 04:50:35PM -0700, Scott wrote:
When I use DBD::Oracle 1.12 with DBI 1.30 (I also saw this on
1.06/1.15) I see two parse_calls for every execute on all selects.
Update/insert/delete just have 1 parse/execute. I have a simple test
script.
#!/usr/local/bin/perl -w
On Wed, Oct 16, 2002 at 07:43:57AM -0700, Michael A Chase wrote:
On Wed, 16 Oct 2002 10:57:36 +0100 Mark Buckle [EMAIL PROTECTED]
wrote:
I know I'm possibly one of those 'born-every-minute' types, but I actaully
bought the O'Reilly book and read it cover to cover
before beginning with
Try doing the disconnect inside the signal handler.
But be aware that doing _anything_ in perl inside an asynchronous
signal handler is prone to problems.
Also be aware that signal handling has changed in perl 5.8 and
you may well find you have a different set of problems then.
Tim.
On Wed,
On Tue, Oct 22, 2002 at 08:37:34PM -0400, Steve Sapovits wrote:
Looks like an Oracle error, which is what I'd expect. I'm just
wondering if Oracle is supposed to support this or not ...
Here's the trace output (sorry for any wrapping):
- prepare for DBD::Oracle::db
One I've not release yet. You may need to make the changes by hand.
Tim.
On Wed, Oct 23, 2002 at 06:53:37AM -0400, Steve Sapovits wrote:
Tim - what version of DBD::Oracle are you starting with? Thanks ...
Tim Bunce wrote:
On Tue, Oct 22, 2002 at 08:37:34PM -0400, Steve Sapovits wrote
On Wed, Oct 23, 2002 at 03:10:05PM +0200, Stephan Harren wrote:
Hello All,
$statement=SELECT device_id FROM devices WHERE monitor=true;
$st1=$db1-prepare($statement) or $err=$DBI::errstr;
$statement=SELECT
ip,probes,packetloss,duration,last_check,sms,mail FROM
Thanks.
On Fri, Oct 18, 2002 at 03:14:02PM +, Robert Thompson wrote:
Hello,
I have been using the great module DBI:Shell via dbish, but I may have come
across a bug. At the least, it did not behave as I expected.
The problem is that when you type the command prefix and
On Tue, Oct 22, 2002 at 03:46:27PM -0400, Nallapati, Ram, CFCTR wrote:
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/pe
rl5/5.00503/sun4-solaris -I/usr/local/lib/perl5/5.00503 test.pl
test.pl
DBI test application $Revision: 10.3 $
opendir(./../../../..):
On Thu, Oct 24, 2002 at 12:33:17AM -0700, Mark Dedlow wrote:
which is what I now realize I have to do if I don't know the
RaiseError status of the statement handles. It seems to me
that most of the code-neatness value that I often see cited
for RaiseError and eval blocks is lost. In
for SET types.
Handle embedded quotes etc in default values etc.
Query mysql db to set initial start value of auto_increment sequence
=head2 AUTHOR
Copyright Tim Bunce, 2001. Released under the same terms as Perl.
=cut
use strict;
use Carp;
use Parse::RecDescent;
use Data::Dumper;
use Getopt
On Fri, Oct 25, 2002 at 06:26:29AM +1000, Steve Baldwin wrote:
Thanks Chris,
I have tried this on DBI 1.30 and DBD::Oracle 1.12, but see exactly the same
behaviour. I suspect it is a DBD::Oracle thing coz as far as I know, named
bind variables (as opposed to ?) is an Oracle thing.
I
On Wed, Oct 23, 2002 at 09:41:19AM -0700, Todd Enersen wrote:
What am I missing? I believe Makefile.PL links to my Oracle 9i libraries
correctly when it's linking:
LD_RUN_PATH=/disks/sc-soldev2-007/oracle/product/9i/lib32:/disks/sc-soldev2
-007/oracle/product/9i/rdbms/lib32
On Fri, Oct 11, 2002 at 02:27:21PM -0700, Henri Asseily wrote:
Perrin, thanks for the synopsis of shm modules. I'll be using IPC::MM,
since I neither need serialization nor presistence.
Regarding what I've dubbed DBIx::HA, here's the idea:
There hasn't been up to now (or at least I
Oracle performance tuning made easy:
Step 1: Buy this book...
Oracle Performance Tuning 101
By Gaja Krishna Vaidyanatha, John A. Kostelac, Kirtikumar Deshpande
Oracle Press, Paperback, Published June 2001, ISBN 0072131454
Step 2: Do what it says.
Tim.
p.s. Run a
On Fri, Oct 25, 2002 at 02:24:03PM -0400, Jeff Thies wrote:
I'm getting this error:
DBI fetchall_hashref: invalid number of parameters: handle + 0
Usage: $h-fetchall_hashref() at test_xsl.cgi line 59.
$tbl_ary_ref = $sth-fetchall_hashref; # error here
What have I missed? The DBI docs
You need to isolate where the slowness is. It might be your perl code,
it might be the database, it might be the drivers or network.
Tim.
On Sat, Oct 26, 2002 at 06:56:28AM -, Bharat wrote:
Hi ,
I am using perl 5.6 with Oracle 8i on redhat Linux 7.2
system, Iam facing probelm
Try:
local $SIG{__WARN__} = sub {};
Tim.
On Mon, Oct 28, 2002 at 01:22:02PM -0500, Jeff Boes wrote:
This is more of a curiosity question than a possible bug report. I have
a customized layer on top of DBI which includes code to enable the
Profile feature; however, the installation
- Forwarded message from d w [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Wed, 30 Oct 2002 13:04:46 +1100 (EST)
From: d w [EMAIL PROTECTED]
Subject: oracle question
To: [EMAIL PROTECTED]
Tim:
I have recently starting using:
- perl 5.8, mod_perl 1.0
- dbi-1.30,
On Wed, Oct 30, 2002 at 07:04:07AM -0800, Jared Still wrote:
The methods found in there are endorsed by the likes
of Cary Millsap, Anjo Kolk, Jonathan Lewis, Mogens
Norgaard and many others. I believe that Cary Millsap
wrote the forward, though I don't have the book in front
of me right
On Wed, Oct 30, 2002 at 09:21:02AM -0600, Duin, Harry wrote:
I am new user of Oracle DBI. I can read non LOB data ok, but can not read
LOB data. I get the error:
DBD::Oracle::db prepare failed: ORA-03115: unsupported network datatype or
representation (DBD: odescr failed)
Your DBD::Oracle
One for the FAQ I think - if it's not there already.
Tim.
On Thu, Oct 31, 2002 at 08:52:43AM -, [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You have two active statement handles and SQL Server does not support multiple
active statements with the standard
On Fri, Nov 01, 2002 at 02:57:44PM +0100, Georg Botorog wrote:
Hi,
I am using DBI and DBD::Oracle. Is there any possibility to get the
names of the bind variables back from OCI, such as returned by
OCIStmtGetBindInfo()?
The background is: I get a statement (defined elswhere) where the
On Fri, Nov 01, 2002 at 09:56:45AM -0500, Dave K wrote:
Question: (thanks for staying with me...)
What is:
OCILobLocatorPtr=SCALAR(0x1ddab58)
I had hoped to gain access to the CLOB through it. Is this possible?
You can try using the Oracle::OCI module.
It comes with examples that use
And the DBI has now defined a $dbh-quote_identifier method.
But I'm not sure if DBD::mysql has implemented it yet.
Tim.
On Tue, Nov 12, 2002 at 12:48:29PM -0600, Paul DuBois wrote:
At 10:27 -0700 11/12/02, Rob Lee wrote:
[Please respond directly to me as this address is not subscribed to this
Wow. That's a lot of code. Personally I'd just do:
$count = $dbh-selectrow_array(select count(*) from ...) or die ...;
(and the or die isn't needed if you're using RaiseError.)
Tim.
On Tue, Nov 12, 2002 at 01:01:21PM -0500, Vorce, Tim (T.) wrote:
Just like any other return from the
When you disconnect you'll probably get a warning about invalidating
1 active statement handle. Either call finish or use a $dbh-selectrow_*
method - that's what they're there for.
Tim.
On Tue, Nov 12, 2002 at 03:28:53PM -0500, Hardy Merrill wrote:
Christopher G Tantalo [[EMAIL PROTECTED]]
Michael has done his usual great job of answering in detail, so I'll
just make an observation...
On Tue, Nov 12, 2002 at 04:33:47PM -0800, Dana Lucent wrote:
As I sit here contemplating my woes over a fresh Martini, I thought that
I might post my problem in the hopes that those PERL guru's from
Be gentle.
- Forwarded message from [EMAIL PROTECTED] via RT [EMAIL PROTECTED]
-
Date: 13 Nov 2002 15:43:42 -
To: AdminCc of perl Ticket #18355: ;
From: [EMAIL PROTECTED] via RT [EMAIL PROTECTED]
Subject: [perl #18355] Perl DBI
Wed Nov 13 07:43:42 2002: Request 18355 was acted
for use with the perl versions shipped with Solaris.
Available on CPAN
Regards,
Dan
Tim Bunce wrote:
Be gentle.
- Forwarded message from [EMAIL PROTECTED] via RT
[EMAIL PROTECTED] -
Date: 13 Nov 2002 15:43:42 -
To: AdminCc of perl Ticket #18355: ;
From: [EMAIL
the DBI, and make life
easier for others who may run into the same problem, by explaining
how the answer is not in the manual. Then I can fix it.
Thanks.
Tim.
On Wed, Nov 13, 2002 at 11:28:50PM -0800, Dana Lucent wrote:
Tim Bunce,
As I sit here reading this tripe, I cannot help but be amazed
reactions when in the future someone in a professional
capacity attributes this drivel to you. I trust you will be able
explain it then.
But as intelligent as you surely are, you thought of all of that, didn't
you!
Peace.
Dana == Dana Lucent [EMAIL PROTECTED] writes:
Dana
Dana Tim Bunce
On Thu, Nov 14, 2002 at 05:28:19PM +, Tim Bunce wrote:
Lets's draw a line under this now please. No one needs it.
Having said that I would like to add *just one* thing:
http://www.tuxedo.org/~esr/faqs/smart-questions.html
I recommend it to everyone. I'll add the link to the DBI docs
On Mon, Nov 18, 2002 at 12:35:25PM -0600, Duin, Harry wrote:
I am rather new to DBI and a few weeks ago I was geven a program by my
Oracle DBA that showed I can write to a
BLOB data type by setting the ora_type attribute in bind to 24, as in:
$sth-bind_param(1, $data, { ora_type = 24 } );
Use trace.
Tim.
On Mon, Nov 18, 2002 at 09:30:50PM -0500, [EMAIL PROTECTED] wrote:
Hi all,
I've got a problem that I absolutely can't figure out, and I was
hoping somebody here might know what's up. I'm running MySQL on Solaris 8
with perl version 5.6.1, DBI version 1.13, mysql DBD
On Tue, Nov 19, 2002 at 05:57:56PM -0500, Jeff Urlwin wrote:
code snippet:
use DBI;
my $dbh = DBI-connect('DBI:ODBC:OST', 'user', 'pass')
or die Couldn't connect to database: . DBI-errstr;
sub get_max_id {
my $be_table=@_[0];
my $st_maxid =
- Forwarded message from Josh Wilmes [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DBD::Oracle / alarm() problem
From: Josh Wilmes [EMAIL PROTECTED]
Reply-To: Josh Wilmes [EMAIL PROTECTED]
Date: Wed, 20 Nov 2002 14:40:53 -0800
Tim,
I appear to be
That's a message for dbi-users. I've directed followups there.
Tim.
On Thu, Nov 21, 2002 at 09:25:13AM -0700, Jason E. Stewart wrote:
Hey all,
I'd be grateful if someone could give me a reality check. I have 250k
rows I want to insert into Postgres using a simple Perl script and
it's
On Fri, Nov 22, 2002 at 03:43:59PM -0700, Jason E. Stewart wrote:
David Duff [EMAIL PROTECTED] writes:
1. 1053 records per second
2. 3225 records per second
3. 3448 records per second
I was seeing about 10 records/sec!! So I'll take any of these
results.
Weren't you also doing a
Perhaps the param() method is returing an empty list for
parameter names that don't exist.
If so, try wrapping each with scalar(...).
Tim.
On Sat, Nov 23, 2002 at 10:04:43PM +0100, Bart Lateur wrote:
On Thu, 21 Nov 2002 15:12:47 -0800, Daniel Olson wrote:
$sth = $dbh-prepare(insert into
Thanks.
Tim.
On Sun, Nov 24, 2002 at 11:40:08AM -0800, David Wheeler wrote:
On Monday, September 9, 2002, at 06:11 PM, Jeff Urlwin wrote:
From perldoc DBI:
If the subroutine returns a false value then the RaiseError
and/or
PrintError attributes are checked and acted upon
On Mon, Nov 25, 2002 at 10:14:55AM +0800, Autrijus Tang wrote:
On Sun, Nov 24, 2002 at 08:20:44PM -0500, Lincoln Stein wrote:
On Sunday 24 November 2002 06:18 pm, Autrijus Tang wrote:
Also I noticed that in Apache2 mod_perl1.99_07 Win2k Perl5.8
DBD::mysql2.1020 DBI1.30, Tie::RDBM
On Mon, Nov 25, 2002 at 04:21:57PM +0100, NYIMI Jose (BMB) wrote:
Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
After DBD::Oracle has been built against a specific version of Oracle
it should continue to be used with that version. So at least ORACLE_HOME
LD_LIBRARY_PATH should be as they were. If you need to support multiple
Oracle installations then it's safest to use multiple DBD::Oracle installations.
Long long ago, on Sun, Sep 15, 2002 at 12:41:18PM -0700, David Wheeler wrote:
* Line 32, I've added the comment # Broken? Changed?. This is because
the behavior of the Kids attribute is somewhat unpredictable. I've
written a separate test for this issue (attached as 07kids.t). When I
run
On Mon, Nov 25, 2002 at 03:56:50PM -0800, David Wheeler wrote:
On Monday, November 25, 2002, at 03:20 PM, Tim Bunce wrote:
I'll look into this.
I'm pretty sure that it's a difference between 5.6.x and 5.8.x. The
Exception::Class::DBI tests have always succeeded since I added a test
Done. Thanks!
Tim.
On Tue, Nov 26, 2002 at 11:13:58AM +1100, Fox, Michael wrote:
its a slightly obscure combination of parameters, but when I set
ora_ph_type=96, my dbms_output from Oracle stored procedures disappeared.
Turns out this setting affected the parameter binding in sub
On Mon, Nov 25, 2002 at 04:15:49PM -0800, David Wheeler wrote:
On Monday, November 25, 2002, at 04:04 PM, Tim Bunce wrote:
Perl 5.8.0 is (quite reasonably) clearing refs in lexical variables
in a more timely manner when the sub exists.
The failing test in 07kids.t isn't testing anything
- Forwarded message from carlo deu [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
From: carlo deu [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Subject: help
Date: Tue, 26 Nov 2002 14:50:50 +0100
X-RAVMilter-Version: 8.4.1(snapshot 20020919) (vaxca1.unica.it)
Hi mr Tim Bunce
Or just @tables = $dbh-tables;
Tim.
On Tue, Nov 26, 2002 at 10:02:03AM -0500, darren chamberlain wrote:
* Chris Rogers [EMAIL PROTECTED] [2002-11-26 09:45]:
Is there a way to get a list of all table names in specific database
using DBI::mysql in Perl?
Can you use SHOW TABLES? E.g.:
Got a moment to gve this more thought...
#!/usr/SD/perl/bin/perl
#use DBD::Oracle;
use DBI;
$SIG{ALRM} = sub { print Caught alarm\n; };
alarm (2);
$dbh = DBI-connect('dbi:Oracle:eman', 'eman', 'eman');
alarm (0);
sleep(5);
print Success\n;
If the use DBD::Oracle
- Forwarded message from kenneth blue [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Wed, 27 Nov 2002 10:35:22 -0800 (PST)
From: kenneth blue [EMAIL PROTECTED]
Subject: need guidance on installing libdbi-perl to existing linux potato
To: [EMAIL PROTECTED]
Tim:
I am new to
Set before prepare. Use trace to see effect. Use recent DBD::Oracle version.
Tim.
On Thu, Nov 28, 2002 at 11:29:20AM +1100, Steve Baldwin wrote:
Can someone please tell me if the RowCacheSize needs to be set before
calling 'prepare' or before calling 'execute' if I want it to be
effective for
here:
http://search.cpan.org/src/TIMB/DBD-Oracle-1.12/Changes
Tim.
Cheers,
Steve
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 28 November 2002 11:41 AM
To: Steve Baldwin
Cc: [EMAIL PROTECTED]
Subject: Re: RowCacheSize - when to set ?
Set
Try $dbh-prepare($call, { ora_check_sql = 0 });
(The underlying issue is either an Oracle bug or that one of the
two parse steps counted isn't a real parse. DBD::Oracle does a
'describe only' execute at prepare() time and then a normal execute
when execute() is called. The execute() should not
On Thu, Nov 28, 2002 at 06:58:00PM -0600, Moritz von Schweinitz wrote:
Tim Bunce wrote:
On Tue, Nov 26, 2002 at 03:54:56PM -0600, Moritz von Schweinitz wrote:
Hi there,
this is kinda OT, since i fear it's more of a mysql than dbi issue, but
here goes...
the thing is that i have
An interesting article on SQL Injection attacks (where a database
query can be modified to perform unintended actions):
http://online.securityfocus.com/infocus/1644
The article has a strong Oracle focus but the issues apply to many
databases (even more so to those that allow multiple
Thanks. That one had already been reported to me and is fixed
in the next release - due any day now.
But do keep looking :-)
Tim.
On Fri, Nov 29, 2002 at 04:33:07PM +0100, Slaven Rezic wrote:
Here's a small documentation fix:
--- ../build/DBI-1.30/DBI.pm Thu Jul 18 16:24:04 2002
+++
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.31.tar.gz
size: 276605 bytes
md5: cd6d40e37ac2cad6db53e7dfbb1baf1c
=head1 Changes in DBI 1.31,29th November 2002
The fetchall_arrayref method, when called with a $maxrows parameter,
no longer gives an error if called again after all rows
to deprecate 5.005_03 in future DBI release, but at
this time I can't find a documentation actually saying that.
And some tweaks for DBI::Profile{Data,Dumper}.pm also applied.
At Sat, 30 Nov 2002 01:04:23 +,
Tim Bunce wrote:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.31.tar.gz
size
On Sun, Dec 01, 2002 at 06:17:48PM +, Tony Bowden wrote:
On Fri, Nov 29, 2002 at 12:33:42PM +0100, Bart Lateur wrote:
I hadn't looked at this thread until now, but now that I do, I do
recognize the pattern. I've had the same kind of problems with Access.
What can fix this, is having an
Thanks!
By commenting out the unlink at the end of the test I can see that
my dbi.prof file looks like this:
--snip--
DBI::ProfileDumper 1.0
Path = [ DBIprofile_Statement, DBIprofile_MethodName ]
Program = t/42prof_data.t
+ 1
+ 2 FETCH
=1 0.000117 0.000117 0.000117 0.000117
Seems like a flawed test: assuming that the cost of the method
call would always be measurable on any platform.
I'll change it.
Thanks.
Tim.
On Sun, Dec 01, 2002 at 04:17:47AM +, [EMAIL PROTECTED] wrote:
This distribution has been tested as part of the cpan-testers
effort to test as many
On Thursday 28 November 2002 04:13, Tim Bunce wrote:
Try $dbh-prepare($call, { ora_check_sql = 0 });
(The underlying issue is either an Oracle bug or that one of the
two parse steps counted isn't a real parse. DBD::Oracle does a
'describe only' execute at prepare() time and then a normal execute
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.32.tar.gz
size: 277594 bytes
md5: 5a6b8fb4433da1a9363a0b2ab1d6f21e
=head2 Changes in DBI 1.32,1st December 2002
Fixed to work with 5.005_03 thanks to Tatsuhiko Miyagawa (I've not tested it).
Reenabled taint tests (accidentally left disabled)
of weeks.
I'll let you know how it turns out.
Please do!
I expect to be working on DBD::Oracle again very soon, after what
has become an extended period of, er, stability.
:)
Tim.
Jared
On Sunday 01 December 2002 13:06, Tim Bunce wrote:
Thanks.
So the next question
Possibly due to errors in Oracle's own Makefile' (which DBD::Oracle
copies chunks of). What do those lines in the generated Makefile
say (and pay special attention to whether lines start with spaces
or tabs).
Tim.
On Mon, Dec 02, 2002 at 12:35:52PM -, Carlos Barroso wrote:
Hy.
I'm trying
On Mon, Dec 02, 2002 at 12:30:04PM +0100, H.Merijn Brand wrote:
On Mon 02 Dec 2002 12:28, H.Merijn Brand [EMAIL PROTECTED] wrote:
On Mon 02 Dec 2002 02:32, David Wheeler [EMAIL PROTECTED] wrote:
Tim,
Got just one warning with the new 1.32 release on Mac OS X 10.2.2:
HP-UX 10.20
, always use the dbi-user
mailing list. Thanks.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 2 de Dezembro de 2002 13:23
To: Carlos Barroso
Cc: [EMAIL PROTECTED]
Subject: Re: Problem installing perl+dbi+dbd-oracle on HP-UX
Possibly due
'. Stop.
make[1]: Leaving directory `/tmp/perl_dbi/perl-5.6.1/x2p'
make: *** [translators] Error 2
Looks like in x2p stuff there's references to targets built-in!?
Still this approach does not work.
Any ideas?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent
On Tue, Dec 03, 2002 at 02:03:49AM -0800, Timothy Johnson wrote:
You never actually use your DataBase Driver, so DBI has no idea how to do
what you've asked. I think this is what the error message is trying to tell
you. Try installing DBD::ODBC and then putting the line use DBD::ODBC at
On Mon, Dec 02, 2002 at 11:49:19AM -0800, Scott Alexander wrote:
I'm just started to prep a new machine for our web cluster. Using CPAN,
I tried to install DBI. It made everything just fine, but when it went
to tests, it failed t/40profile. The test uses Time::HiRes which wasn't
installed
On Mon, Dec 02, 2002 at 06:25:35PM -0800, Dean Arnold wrote:
Someone reported the following error occuring w/ DBI 1.32 and
DBD::Chart:
[Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db do failed: No rows
attribute supplied to prepare at c:/Perl/site/lib/Deakin/Base.pm line
2822.
[Tue
Please show a (very) small example script.
Tim.
On Tue, Dec 03, 2002 at 02:31:01PM -0500, Trey Gregory wrote:
I'm sure this has been answered before, but I wasn't able to find anything in the
archives. (Is there a search interface available?)
I have a multithreaded program. My problem is
Thanks Jonathan. I'll look into it. The Makefile is probably missing
a dependency.
Tim.
On Sun, Dec 01, 2002 at 08:24:26PM -0800, Jonathan Leffler wrote:
Dear Tim,
An odd one, and I'm not sure whether you even want to do anything
about it, but...
I was using 'cpan' from Perl 5.8.0
301 - 400 of 2336 matches
Mail list logo
