On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
Peter Schuberth wrote:
On the same hardware system
the same select for the same table
Please check your version of SQL::Statement which is the module that
determines the speed and capabilities of DBD::CSV. Put these two lines
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
I have this script:
use strict;
use warnings;
use DBI;
my %attr = (
PrintError = 0,
RaiseError = 1
);
my @drivers = DBI-available_drivers();
foreach my $driver(@drivers) {
print Driver: $driver\n;
my
I've discovered that DBD::mysql will return tablefoo.fieldbar as
the NAME of the field in a select like:
SELECT tablefoo.fieldbar FROM tablefoo
It does that simply because that's what the underlying mysql client
API tell it is the name of the field.
I believe this is very rare (I know of no
On Mon, Mar 03, 2003 at 09:43:45PM -0800, Jonathan Leffler wrote:
Tim Bunce wrote:
package name at C:/Perl/site/lib/DBD/Proxy.pm line 272.
BEGIN not safe after errors--compilation aborted at
C:/Perl/site/lib/DBD/Proxy.pm line 414.
Compilation failed in require at (eval 3) line 3.
*** lib
It looks like a false alarm. I can't reproduce it outside Class::DBI
(using mysql client, or DBD::mysql, using v3 or v4) so I need to
dig deeper into Class::DBI to see what's happening there.
Tim.
On Mon, Mar 03, 2003 at 06:39:01PM -0600, Paul DuBois wrote:
At 0:18 + 3/4/03, Tim Bunce wrote
- Forwarded message from [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Subject: DBD::Oracle and AIX 5.1 64 bit
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Tue, 4 Mar 2003 11:40:32 +0100
Hallo,
do you have experience with AIX 5.1 64 bit mode and DBD::Oracle?
I have a
On Mon, Mar 03, 2003 at 08:20:34PM -0500, Bob X wrote:
Tim Bunce [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
snip
Thanks. I believe the appended patch fixes it.
Tim.
*** lib/DBD/Proxy.pm2003/02/28 17:50:06
On Tue, Mar 04, 2003 at 04:33:59PM +0100, Andreas Koch wrote:
After successful installation of Perl and DBI, i get some errors installing
the DBD 1.12. What can i do to fix it?
There are no errors, only warnings. The short story is that DBD::Oracle
has not yet been updated for recent perl
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
Tim Bunce wrote:
On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
use SQL::Statement;
print $SQL::Statement::VERSION;
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing
On Tue, Mar 04, 2003 at 10:45:45PM -, Simon Taylor wrote:
Will this include support for Oracle 8 objects?
Is your cheque in the mail?
;-)
Let's get the ball rolling bfore we try to steer it shall we?
Tim.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: 04
On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
While trying to test some multiprocessing on Win2K (ActiveState 633), I ran
into
an issue I'm hoping you can shed some light on. If I open a $dbh before
forking
off some kids that also open some $dbh's, I get the following error in
On Tue, Mar 04, 2003 at 04:21:10PM -0800, Dean Arnold wrote:
On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
While trying to test some multiprocessing on Win2K (ActiveState 633), I
ran
into
an issue I'm hoping you can shed some light on. If I open a $dbh before
forking
On Tue, Mar 04, 2003 at 10:58:22PM -0500, Jeff Thies wrote:
I have an Access database with funny field names like: REPORT #
I forgot the advice to use square brackets [] and used double quotes
instead : REPORT #.
Now, that works fine. But is that going to cause me trouble
On Wed, Mar 05, 2003 at 02:36:50PM +, Volker I. Lipper wrote:
Hi Jeff,
the correct syntax in access itself would be:
#9/30/1999#
the writing of the data (mm.dd or dd.mm or mm/dd) belongs to the
system variables set on the system acess is installed on. But in
every case you have
On Wed, Mar 05, 2003 at 01:38:58PM -0500, Jeff Thies wrote:
Tim Bunce wrote:
On Wed, Mar 05, 2003 at 02:36:50PM +, Volker I. Lipper wrote:
Hi Jeff,
the correct syntax in access itself would be:
#9/30/1999#
the writing of the data (mm.dd or dd.mm or mm/dd) belongs
On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
I have a very long running Perl process. I recently upgraded the
DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
memory. Given the complexity of the project, it's not possible to
reduce it to a simple test
On Fri, Mar 07, 2003 at 09:24:51AM -0500, Cory Rau wrote:
Hmmm...I did that. And now I get a different error:
Argument isn't numeric in repeat (x) at /Library/Perl/darwin/DBD/Proxy.pm line
63.
Change the
5 x ' '
to
' ' x 5
on the line with the error. It's
to use fetchall_arrayref?
Also,is $dat-fetch the same as $dat-fetchrow_arrayref?
Thanks.
Guang
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tim Bunce
Sent: Friday, March 07, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: perl DBI
http://www.google.com/search?q=sql+null+three+value
Tim.
On Fri, Mar 07, 2003 at 04:36:41PM -0500, Rick Nakroshis wrote:
I just installed DBI v1.34 and DBD-ODBC v1.04 on my AS build 633, and
have a question about a query that I tried to test the ODBC connection
to our SQL Server database:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.35.tar.gz
size: 288058 bytes
md5: 8ede0b8817ac8b0db6cc5db36109060c
NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier.
: Perl 5.6.1 will be the minimum supported version.
NOTE: The old-style connect:
On Mon, Mar 10, 2003 at 12:26:51AM -0800, Victor A. Rodriguez wrote:
I run through the same problem a few days ago, and I
just fetched all the rows in a hash with
fetchall_arrayref, finish()ed the query and performed
a do() again.
If you fetch all the rows you should not need to call
Thanks for posting the answer for the archives.
Tim.
On Mon, Mar 10, 2003 at 04:54:00PM +, Greg Thompson wrote:
I found an answer to my problem regarding the use of
mysql_read_default_file and my perl script crashing. According to:
foreach ( $cgi-param() ) {
push @cols, $_;
push @vals, $cgi - param( $_ );
}
my $sql = INSERT INTO table ( . join( , , @cols ) . )\n .
VALUES ( . join( , , map { ? } @cols ) . );
Seeing all that 'line noise' makes me think we need a neater way.
Personally I'd have written
On Mon, Mar 10, 2003 at 02:39:36PM -0800, Jeff Zucker wrote:
Tim Bunce wrote:
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing? That doesn't work for me
From memory... it needs a non-lexical
On Mon, Mar 10, 2003 at 03:47:31PM -0800, Jeff Zucker wrote:
Paul Boutros wrote:
my $sql = qq{
INSERT INTO table
( ${\comma_separated_values(@col)} )
VALUES ( ${\comma_separated_placeholders(@col)} )
};
I'm not sure I like this, but if it is to be used, a better name might
On Mon, Mar 10, 2003 at 10:51:21PM -0500, Matthew O. Persico wrote:
I am using Perl 5.6.1, DBI 1.32 and DBD::Oracle 1.12. I have decided to upgrade to
DBI 1.35 BEFORE reporting a problem I am having.
I built DBI 1.35 with no problems. Then I tried to rebuild DBD::Oracle 1.12.
1) compile
On Mon, Mar 10, 2003 at 10:55:26PM -0500, Matthew O. Persico wrote:
I am calling bind_param like this:
$sth-bind_param($col_idx,
$value,
{TYPE =?DBI::SQL_VARCHAR});
for a column
. Is there any other better way so
that I can minimize the calls to the SQL/PL. Please let me know.
I don't think so.
Tim.
Regards
Murugan
- Original Message -
From: Tim Bunce
Sent: Tuesday, March 11, 2003 3:08 PM
To: murugan mohan
Cc: Tim Bunce
Subject: Re: bind param array
Maybe
On Tue, Mar 11, 2003 at 07:03:30PM -0500, Matthew O. Persico wrote:
On Tue, 11 Mar 2003 21:26:56 +1100 (EST), Mark Ashley wrote:
So using the truss output I went through each file it was missing
and copied it into the local tree. My finished tree consists of:
This REALLY needs to get into
On Tue, Mar 11, 2003 at 09:28:50PM -0500, Matthew O. Persico wrote:
--- Original Message ---
From: M. Addlework [EMAIL PROTECTED]
To: Matthew O. Persico [EMAIL PROTECTED]
Cc:
Sent: Tue, 11 Mar 2003 15:59:27 -0800 (PST)
Subject: Re: Fwd: Cannot bind a single blank space to a non-null varchar?
On Wed, Mar 12, 2003 at 01:46:48PM +0100, Bernhard Donaubauer wrote:
Hello!
I have a problem to insert NULL values in CLOB/BLOB fields.
I think that's not currently supported. Patches welcome.
Tim.
In the following example I insert four records into a testtable. The third row
causes my
Just looks like some left-over debugging. If unsigned short
columns are fetched okay then you can probably ignore the warning.
Tim.
On Wed, Mar 12, 2003 at 05:32:07PM +0100, Stephan Harren wrote:
I did, my first mail was:
---snip---
I'm working on a perl-script connecting to myqsl using
is, that there are no
short columns in MySQL. Maybe my knowledge on databases is too little, but
maybe you can give me an explanation for that?
Best regards,
Stephan
Am Mittwoch, 12. März 2003 18:47 schrieb Tim Bunce:
Just looks like some left-over debugging. If unsigned short
columns are fetched okay
On Thu, Mar 13, 2003 at 09:57:12AM +0100, [EMAIL PROTECTED] wrote:
www.perl.com/CPAN should work nicely :)
Latest stable version of DBI would appear to be 1.30. Changes coming a bit
too fast to call the newer versions 'stable' though (sorry Tim).
No need to appologise.
The only problems
On Thu, Mar 13, 2003 at 07:43:17AM -0600, James.FitzGibbon wrote:
There is one outstanding issue that I am aware of. We reported a problem
setting the RootClass
attribute in DBI v1.30, which was addressed in v1.31. Unfortunately, the
fix has a small problem.
Here is the original message
[EMAIL PROTECTED]
instructions in README.hpux\n ;
---
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
If at first you don't succeed, skydiving isn't for you
-Oorspronkelijk bericht-
Van: Tim Bunce [mailto:[EMAIL PROTECTED]
Verzonden
Looks like you're using DBI v1.32. Try DBI 1.35
Tim.
On Fri, Mar 14, 2003 at 02:22:38PM +0800, [EMAIL PROTECTED] wrote:
Dear sir,
I have a problem with installing the DBI. I get 2 test failed
when I perform make test and make test TEST_VERBOSE=1.
Attached is the
logging message.
Thank
Buy this book: Oracle performance tuning 101. You won't regret it.
Tim.
On Fri, Mar 14, 2003 at 10:54:24AM +0100, Filipe Vasconcelos wrote:
Hello,
Does anybody has any script that could give, detailed information about the
performance of an Oracle Database.
regards,
After over 18 months of stability it gives me great pleasure to
say that the monstrous hunk of rock that is DBD::Oracle is rolling
forward once again...
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.13.tar.gz
size: 194630 bytes
md5: bcb1a887ac8f5da415a78fe7abb012b5
Special thanks are due
Please ignore previous test email to [EMAIL PROTECTED]
I'd forgotten that I'd set [EMAIL PROTECTED] to redirect to dbi-users.
Tim.
On Mon, Mar 17, 2003 at 12:04:22PM -0800, Michael A Chase wrote:
On Mon, 17 Mar 2003 05:07:36 -0600 Moritz von Schweinitz [EMAIL PROTECTED] wrote:
i'd just like to recommend some more hash-friendly routines for these
kind of operations. i know that they are relativly tricial to code, but
finish() should be probably be called discard_pending_results().
It should only ever be used for SELECT statements where you have
not fetched past all the returned rows. (In which case it avoids
the warning message you'd otherwise get.)
Tim.
On Tue, Mar 18, 2003 at 10:17:19AM +0100, alex wrote:
Try DBD::Oracle 1.13.
Tim.
On Mon, Mar 17, 2003 at 03:58:11PM -0800, Maggie Wing (Sun Contractor) wrote:
Hi.
I've been trying for a week now to install DBD on my
development machine. I was able to get the DBI installed,
but make-test (and by extension, yours truly) keeps failing
with
Thomas, did you get round to doing this?
Tim.
On Wed, Feb 26, 2003 at 10:54:12AM +, Tim Bunce wrote:
On Tue, Feb 25, 2003 at 05:30:31PM -0500, Thomas Good wrote:
On Tue, 25 Feb 2003, Tim Bunce wrote:
While I was using 5.8 large data transfers via DBI failed consistently.
I have
On Wed, Mar 19, 2003 at 10:07:20PM +1000, Brook Schofield wrote:
I've been unable to install DBD::Oracle on MacOS X
I have:
MacOS X 10.2.4
Perl 5.8.0
DBI-1.35
DBD::Oracle-1.13
Oracle Developer Editior 9iR2 for MacOS X
the core errors that I receive are during 'make test':
Perl 5.005 is not supported by the DBI. You may find 5.005_03 will work
(but that version is also very old and the DBI soon won't support that).
I'd recommend using perl 5.6.1.
DBI-1.201 is also very old. Try 1.35.
Tim.
On Wed, Mar 19, 2003 at 12:38:43PM +, Venky Karuppur wrote:
Hello All,
On Thursday, March 20, 2003, at 12:05 AM, Tim Bunce wrote:
the first step is for you to try manually building one of the Oracle
examples.
If you can't get that to work then it's very much Oracle's problem.
If you can, then we need to tweak DBD::Oracle's Makefile.PL to do the
right thing for you.
On Wed, Mar 19, 2003 at 10:21:20PM +, Tim Bunce wrote:
On Thu, Mar 20, 2003 at 07:59:52AM +1000, Brook Schofield wrote:
I haven't yet attempted the examples but I was hoping that the
instructions and associated downloads from Tom Mornini
([EMAIL PROTECTED]) where more widely
into Makefile.PL. Thirdly, ... anything else to make life easier...
Tim.
-Brook
On Thursday, March 20, 2003, at 08:37 AM, Tim Bunce wrote:
On Wed, Mar 19, 2003 at 10:21:20PM +, Tim Bunce wrote:
On Thu, Mar 20, 2003 at 07:59:52AM +1000, Brook Schofield wrote:
I haven't yet attempted
- Forwarded message from Carlos Ferreiro [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
From: Carlos Ferreiro [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Oracle 9i and DBD::Oracle
Date: Thu, 20 Mar 2003 09:40:01 +0100
X-MDRemoteIP: 192.168.0.249
X-Return-Path: [EMAIL PROTECTED]
I'm sure this could be done with much less code.
Any volunteers to try to create a shorter version?
Perhaps using selectall_hashref().
Tim.
On Fri, Mar 21, 2003 at 04:39:13PM -0800, Colette Lamm wrote:
I have successfully created code that generates a popup_menu with the fields
id name. I
On Fri, Mar 21, 2003 at 05:43:08PM -0500, SMITH,MICHAEL C (HP-PaloAlto,ex1) wrote:
I'm having a problem installing the DBI module on a Red Hat 8.0 system,
using Perl 5.8.0. There are two problems that show up in the build,
relating to t/40profile.t test and t/42prof_data.t.
Those problems
Upgrade to DBD::Oracle 1.13 first, then try again.
Tim.
On Mon, Mar 24, 2003 at 04:57:44PM +0100, Salvatore Sorrentino wrote:
Dear Sirs, could you help me in resolving the following error installing
DBD under Slackware? Here is the error:
bash-2.05a# perl Makefile.PL
Using DBI 1.33
On Tue, Mar 25, 2003 at 09:04:41AM +0100, [EMAIL PROTECTED] wrote:
Hi all,
Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
problems connecting to some test databases I have setup. Do I need to
On Tue, Mar 25, 2003 at 09:06:16AM +0100, Salvatore Sorrentino wrote:
Thanks for your answer.
I upgraded to DBD::Oracle 1.13 then I tried again.
This time things seems better but nevertheless there is an error:
ocidfn.h and ociapr.h include files are missing.
Could you please help me again?
to lib32. And to run you are going to have to update
your SHLIB_PATH to point to $ORACLE_HOME/lib32.
Lincoln
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 5:38 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: DBD:Oracle
,
---
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
If at first you don't succeed, skydiving isn't for you
-Oorspronkelijk bericht-
Van: Tim Bunce [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 25 maart 2003 17:39
Aan: [EMAIL PROTECTED]
CC: [EMAIL
On Tue, Mar 25, 2003 at 09:55:40AM -0700, Ken Miller wrote:
I've got a strange problem with Apache::Session, and DBD::Oracle:
[Tue Mar 25 10:01:03 2003] [error] Invoking view: /security/list-users.html
-- DBH LONG READ LEN: 256000 --
-- STATEMENT LONG READ LEN: 256000 --
[Tue Mar 25
Smells of memory corruption. Not good.
If you can turn that script into a patch to the t/longs.t that
demonstrates the problem (just to save me some time), I will attempt
to fix it asap.
Just send it direct to me along with a summary of your configuration
(perl -V output, DBI version, Oracle
Exactly. use strict; and -w are your friends.
Tim.
On Tue, Mar 25, 2003 at 08:39:41PM -0600, Chris R. Donnelly wrote:
Are you using a single-quoted or double-quoted string? Remember that Perl
will evaluate arrays in double-quoted strings, so it is likely that is
happening... do you not have
On Tue, Mar 25, 2003 at 01:12:55PM -0600, Chris R. Donnelly wrote:
We are encountering a similar issue at our company, but it seems to be
very specific in what it is affecting. Whenever we build
DBI/DBD::Oracle against Oracle 9.2 on either Linux or Solaris (32-bit; I
did the trick you
On Wed, Mar 26, 2003 at 03:06:24AM -, Peter Scott wrote:
I have an Oracle account which is restricted to one simultaneous
connection at a time. Attempts to exceed this number result in
the later attempts blocking until the first connection is terminated.
Is there anything in DBD::Oracle
Both problems can be ignored.
But do note that perl 5.5.3 will not be supported by the DBI soon.
You should upgrade to perl 5.6.1 or later.
Tim.
On Wed, Mar 26, 2003 at 03:24:49PM +1000, [EMAIL PROTECTED] wrote:
Hi,
Can anyone help me in determining if the following error during make test
be using right?
Yeap. I wasn't very clear. Thanks.
Tim.
Hmmm...
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 6:55 AM
To: Chris R. Donnelly
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re
On Wed, Mar 26, 2003 at 08:07:31AM -0600, Neibarger Scott H wrote:
I'm going to have a multi-threaded daemon application on each TEC server
that will have all of the logic necessary to perform the appropriate
application. Within the TEC rules engine, I will have developed external C
shared
Phone: 32258380
Tim Bunce
On Thu, Mar 27, 2003 at 01:53:16PM -0500, [EMAIL PROTECTED] wrote:
$sql-fetch_rowarray() returns a LIST. You are capturing the count of that list.
Actully fetch_rowarray() returns just the first element when
called in a scalar context.
Perhaps the problem is that the statement returns more than
Oops, yes, it's fetchrow_array()
Tim.
On Thu, Mar 27, 2003 at 11:11:53AM -0800, Brian McCain wrote:
Do you guys mean fetchrow_array() or is there a function (
fetch_rowarray() ) I've overlooked?
-Brian McCain
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: [EMAIL
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz
size: 199667 bytes
md5: ec364509df5dfd57a4c05e2c410f358f
=head1 Changes in DBD-Oracle 1.1427th March 2003
NOTE: OCI 7 and Oraperl will not be supported in future releases.
Implemented inserting NULL values into LOB fields
Tim Bunce
On Fri, Mar 28, 2003 at 05:27:48PM +0100, H.Merijn Brand wrote:
On Thu 27 Mar 2003 19:13, Tim Bunce [EMAIL PROTECTED] wrote:
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz
size: 199667 bytes
md5: ec364509df5dfd57a4c05e2c410f358f
Something changed since 1.14-gamma2:
It's
I believe this is a known perl bug (Can't use FETCH while inside a FETCH).
CC'd to perl5-porters for confirmation.
Tim.
On Fri, Mar 28, 2003 at 04:27:41PM +0100, Silvio Wanka wrote:
Hi,
there is a strange problem with usage of DBI inside the FETCH method
of a tied hash. I have inherited
You can ignore those errors.
Tim.
On Fri, Mar 28, 2003 at 03:57:39PM -0500, Steven Todesco/Cambridge/IBM wrote:
iI,
When installing the DBI 1.35 I had errors on the make test. I bolded the
errors below.
Thanks,
STeve
This is everything starting with the Makefile.PL
$ perl
Tim Bunce
[EMAIL PROTECTED]To: [EMAIL PROTECTED
[dbi-dev isn't the right place for this, so I've removed it from the CC list.]
On Fri, Mar 28, 2003 at 12:43:50PM -0600, Michael Muratet wrote:
Greetings
my $rth = $dbh-prepare(SELECT * FROM demographics_1 WHERE KEY1=$key);
$rth-execute();
while (my $ref2 =
On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
I have discovered that it is the placement of single quotes around the
key value in the query:
my $rth = $dbh-prepare(SELECT * FROM demographics_1 WHERE
KEY1=$key);
that makes the difference. The above takes 90
On Mon, Mar 31, 2003 at 02:01:30PM -0800, Michael Peppler wrote:
On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote:
This worked pretty well before. But, now, it appears that if the result of
the query is a null set, it pukes with a:
Can't get DBI::st=HASH(0x811cfa8)-{NAME}:
Try the appended patch. Please let me know if it works.
Tim.
--- oci8.c 2003/03/27 16:44:15 1.38
+++ oci8.c 2003/03/31 23:28:46
@@ -1630,7 +1630,7 @@
Unable to parse table name for LOB refetch);
OCIHandleAlloc_ok(imp_sth-envhp, dschp, OCI_HTYPE_DESCRIBE,
On Tue, Apr 01, 2003 at 11:59:10AM +0200, Davor ?eker wrote:
Hi guys,
I had a lot of problem to connect from another machine to Oracle Database and thanks
to README and this site I fix it ,but now I need your help.
dbdimp.c, line 263.13: 1506-046 (S) Syntax error.
Ah, a stray C++ style
- Forwarded message from win harrington [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Wed, 2 Apr 2003 07:14:57 -0800 (PST)
From: win harrington [EMAIL PROTECTED]
Subject: postgres with perl dbi
To: [EMAIL PROTECTED]
Tim Bunce --
We bought your excellent book on Perl DBI. Do
On Wed, Apr 02, 2003 at 01:37:56PM +0200, Christian Mondrup wrote:
Tim Bunce wrote:
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz
size: 199667 bytes
md5: ec364509df5dfd57a4c05e2c410f358f
=head1 Changes in DBD-Oracle 1.1427th March 2003
NOTE: OCI 7 and Oraperl
fork on windows is emulated using threads - and that's a whole big can or worms.
Tim.
On Wed, Apr 02, 2003 at 10:19:18AM -0500, Mike Boyle wrote:
I am trying to fork off a series of child processes (~10) having each child
connect to an Oracle 8i database . The child should process the data and
On Thu, Apr 03, 2003 at 04:36:36PM +0200, Wojciech Pietron wrote:
Hi Tim,
have you ever planned to add 'MaxRows' attribute to selectcol_arrayref
function as it is in selectall_arrayref? I thing there is a need for
such an attribute.
I hadn't thought about it. I could do I guess.
Tim.
On Thu, Apr 03, 2003 at 11:02:19AM +0200, H.Merijn Brand wrote:
On Thu 27 Mar 2003 19:13, Tim Bunce [EMAIL PROTECTED] wrote:
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz
size: 199667 bytes
md5: ec364509df5dfd57a4c05e2c410f358f
=head1 Changes in DBD-Oracle 1.1427th
On Wed, Jun 04, 2003 at 12:22:19PM -0700, Jeff Zucker wrote:
Tim Bunce wrote:
SELECT $cols FROM tbl1@$dsn1 ... JOIN tbl2@$dsn2 ...
Both are a little ugly and prone to nested quote problems.
Ew, nested quote problems, the bane of my existence. I guess I was
seeing
I heard it was a limitation of OCI. The kind of connection you needs
uses a lower level API that's not publically available. If it was, I'd add it.
Tim.
On Thu, Jun 05, 2003 at 05:32:28PM +0100, Alan Burlison wrote:
Gold, Samuel (Contractor) wrote:
Yes, I am aware of that, but you still need
So do you all think that setting ora_session_mode to ORA_SYSDBA should force
the password to be non-null?
Tim.
On Fri, Jun 06, 2003 at 07:26:12AM -0400, Gold, Samuel (Contractor) wrote:
Very interesting.
-Original Message-
From: Alan Burlison [mailto:[EMAIL PROTECTED]
Sent:
I think changes to SHLIB_PATH (like LD_LIBRARY_PATH) don't affect
the running process. Someone posted an example some weeks ago that
sets the end var then re-executes the script - that would work.
Tim.
On Fri, Jun 06, 2003 at 02:43:13PM +0200, Wolf, Dr. Stefan wrote:
Hi,
i have a oracle
This is much faster and more accurate:
if ( DBI::looks_like_number($rv) ) {
...
}
Uses perl's own internal code.
Tim.
On Wed, May 28, 2003 at 02:36:26PM -0600, Ian Harisay wrote:
I read the other responses. It is hard to determine what is happening
without
- Forwarded message from Brant Winter [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
From: Brant Winter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DBI t/40profile.t issues
Date: Thu, 29 May 2003 14:38:14 +1000
X-MDRemoteIP: 192.168.1.72
X-Return-Path: [EMAIL PROTECTED]
- Forwarded message from Brant Winter [EMAIL PROTECTED] -
Tim - I am having huge issues installing DBI on a Linux RedHat8.0
server. I need it as a dependency for PerlDesk. Without it I cannot go
any further. I am looking at some issues raised with you in the
following forum, but I
- Forwarded message from Dan Wilga [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Thu, 29 May 2003 16:27:02 -0400
To: [EMAIL PROTECTED]
From: Dan Wilga [EMAIL PROTECTED]
Subject: DBI::ProxyServer 0.3005 (1.37)
Hi there,
I would have posted this to perl.dbi.dev, but my news
TIMESTAMP will be supported in the next release.
Thanks.
Tim.
On Thu, May 29, 2003 at 04:45:23PM +0800, XIE,KE-XIAN (HP-China,ex2) wrote:
Hi bunce,
I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl
5.8.0 64bit, DBI 1.30 64bit.
When I use dbi to fetch the data typed
No. Sorry.
Tim.
On Thu, May 29, 2003 at 03:10:55PM -0500, Jones Robert Contr TTMS Keesler wrote:
Is there a way to shut down an Oracle database with DBI?
Robert Jones, BSCS, BSP
You can almost certainly ignore it. The test is too sensitive to
perl internals. But I can't reproduce it with my 5.6.1 so it is odd.
(You did a 'make test' of your perl before installing, I presume.)
Line 79 of t/15array.t should look like this:
return [ $index, 'a','b','c' ];
You
- Forwarded message from [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Mon, 2 Jun 2003 20:12:49 +0800 (CST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: metadata
X-SHIP: 219.150.96.110
X-SHMOBILE: 0
X-SHBIND: 0
hi:
can dbd::oracle add support to meta data of
http://groups.google.com/groups?q=+%22DBI-1.37+make+test+failures%22
Tim.
On Tue, Jun 03, 2003 at 04:19:42PM -0400, [EMAIL PROTECTED] wrote:
Greetings,
On a SPARC Solaris 8 box with all current patches, gcc-3.2.2 (compiled to
use solaris ld and as), mysql 4.0.13, perl 5.8, and DBI 1.37, I
There's probably a way to do that using Oracle OLAP queries in 9i.
But I'm not familar with the syntax, sorry.
Tim.
On Wed, Jun 04, 2003 at 08:00:17AM -0700, Dean Arnold wrote:
A DBIx::Chart user is experiencing problems with the following query:
$rsth = $dbh-prepare(
SELECT
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 5:15 PM
To: Tim Bunce
Cc: DBI User's List
Subject: Re: Make Test Error?
On Tue, 3 Jun 2003, Tim Bunce wrote:
http://groups.google.com/groups?q=+%22DBI-1.37+make+test+failures%22
Many thanks!
--Duncan
501 - 600 of 2336 matches
Mail list logo
