es it resolutely refuse to work
With the transformed data.
I realise hat this isn't specifucaly a dbi issue, but I am using the dbi to
do this work, so I thought I'd ask the group for help.
Thanks,. Mark
Mark Buckle, Database Administrator, Software - Insurance Technology
Solutions Ltd
Tel: 01
Correction, the error doesn't occur with DBD-Oracle-1.14!!!
Cheers, Mark
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 09:37
To: '[EMAIL PROTECTED]'
Subject: RE: $dbh->tables() printing error messages for Oracle under
Michael,
Thanks for that reply. The error still occurs with DBD-Oracle-1.14, but
I'll replace the deprecated call with your suggestion.
Mark.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: 30 October 2003 23:35
To: Mark Buckle; '[EMAIL PROTECTED]
327.
Use of uninitialized value in string eq at
/usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/DBD/Oracle.pm line 327.
DBI version 1.38
DBD::Oracle version 1.12
Oracle client and server version 8.1.7
Has anyone any ideas what this could be ?
Thanks Marks
Mark Buckle, Database Administra
Have the random failures with prepared statements been fixed ?
Cheers, Mark
-Original Message-
From: Henrik Tougaard [mailto:[EMAIL PROTECTED]
Sent: 19 September 2003 12:27
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: DBD::Ingres 0.50 uploaded to CPAN - now
I've compiled 1.14 against Oracle 9.2 running on Windows. I compiled in the
cygwin environment, using perl 5.8.1 ( I believe.) It was the most trouble
free
Oracle DBD installation I've ever done.
Mark.
-Original Message-
From: Gideon Wheeler [mailto:[EMAIL PROTECTED]
Sent: 08 September
Ok, I'm looking at select_row_ right now
but quickly does this avoid netwroking round-trips, or just simplify coding
?
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: DBD::Oracle - pr
I've noticed that using a prepare/execute/fetch_ cycle of operations
appear to result in 2 parses happening. ( results obtained
from tkprof ) Is this correct ? ie the parse count for the statement will
be 2, the execute count 1, and the fetch count n.
A second querstion is :-
Is it possible
Has anyone attempted this ?
Has anyone succeeded ?
Mark
**
This e-mail may contain information that is privileged, confidential
or otherwise protected from disclosure. It must not be used by, or
its contents copi
And I should have added
and it worked ..
-Original Message-
From: Mark Buckle
Sent: Tuesday, July 01, 2003 2:34 PM
To: Mark Buckle; '[EMAIL PROTECTED]'
Cc: [EMAIL PROTECTED]
Subject: RE: Error building DBD::SYSBase 1.00 against freetds 0.61
lib -lct -ltcl -lintl -ltds -lm -liconv
LDLOADLIBS = -L/usr/local/lib -lct -ltcl -lintl -ltds -lm -liconv
BSLOADLIBS =
LD_RUN_PATH = /usr/local/lib:/usr/lib
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 10:18 AM
To: '[EMAIL PROTEC
s
with the stable version as well.
Thanks, Mark.
-Original Message-
From: Michael Peppler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 8:30 AM
To: Mark Buckle
Cc: [EMAIL PROTECTED]
Subject: Re: Error building DBD::SYSBase 1.00 against freetds 0.61 on
cygwin ( 1.3.22-1)
On Mon,
I've built freetds, using the default install directories and am trying to
compile DBD::Sybase against it with little success.
Can anyone point me in the right direction ?
Thanks, Mark.
bash-2.05b$ export SYBASE=/usr/local
bash-2.05b$ perl Makefile.PL
Sybase OpenClient found.
The DBD::Sybase m
I've had the occasional problem building DBD-Ingres myself on some of our
servers - Bull Escala running AIX 4.3.
The problem showed itself with a similar to that below :-
install_driver(Ingres) failed: Can't load
'blib/arch/auto/DBD/Ingres/Ingres.so'
for module DBD::Ingres: dynamic linker: /usr/lo
Tell IBM/Bull that ..
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 1:55 PM
To: Fernando Luna
Cc: [EMAIL PROTECTED]
Subject: Re: Running SQL from files - was: Your DBI book
Fernando Luna wrote:
> [...]
> I am run
Stick them in a here document and parse them out as separate SQL statements
by splitting on ';' or whatever does separate them.
Strip out comments first - and do a check to ensure ';' doesn't appear in a
literal string and you should be OK.
This is something I use from time to time.
Of course you
OK, thanks, 0.45xx didn't seem to be any better, so I decided to post the
errors to the group.
Mark.
[Mark Buckle] -Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2002 15:34
To: Mark Buckle; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: :ODBC
Thanks, Henrik.
If interfacing perl and C were not so tangled and twisted, I'd have a go
myself. !!!
Roll-on Perl 6 !
Mark.
-Original Message-
From: Henrik Tougaard [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2002 11:53
To: Mark Buckle
Cc: '[EMAIL PROTECTED]'; [EMAIL PRO
I have a generic script to copy data sets around different databases, ie
select from one table, insert into another. I've got problems on ingres
with this.
DBD::Ingres ( 0.30) cannot cope with $sth->execute ( @array_of_values) ;
on prepared insert statements that use place-holders, where one or
Has anyone built this, I'm getting this error when trying to build the
pre-requisite package gdtextUtil-0.80 :-
bash-2.05b$ perl Makefile.PL
Checking if your kit is complete...
Looks good
C:\cygwin\bin\perl.exe: *** unable to remap C:\cygwin\bin\cygpng12.dll to
same address as parent(0xB9) !
bash-2.05b$ perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=cygwin, osvers=1.3.12(0.5432), archname=cygwin-multi-64int
uname='cygwin_nt-5.0 kmbestst 1.3.12(0.5432) 2002-07-06 02:16 i686
unknown '
config_args='-de -Dmksymlinks -Dusemul
Has any-one run into these errors, and have a quick solution, or know
whether or not they can be ignored safely ?
I'm installing it into a private directory because I have no system access,
and have had no problem installing other perl modules and earlier versions
of the DBI this way in the past.
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 the DBI. Now I know DBI has moved on a few versions
since then, but the stuff I use every doesn't seem to have
changed one bit.
Mark.
-Origin
Building this I noticed that it depends on Devel::Peek ( unlike 1.20 )
Are there any others ? I suspect Win32/OLE/Variant.pm is needed
Or is it ADO.pm ?
BEGIN failed--compilation aborted at
/u1dcf01/perl/lib/site_perl/5.005/aix/DBD/ADO.pm line 562
I didn't notice these metioned in the release
Thanks Tim.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 10:52
To: Mark Buckle
Cc: dbi-users
Subject: Re: Float precision - DBD Oracle
On Mon, May 20, 2002 at 09:15:20AM +0100, Mark Buckle wrote:
>
> I'm not sure of the best place to lo
Well I've tested this myself on a set of values in the range of 1e32 to
1e-32 and found no problems.
Cheers.
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 09:15
To: dbi-users
Subject: Float precision - DBD Oracle
I'm not sure of the bes
I'm not sure of the best place to look for this information, hence this
mail.
If I retrieve a float value from an Oracle database, say using
selectall_arrayref, can I be sure that the value is retrieved without
losing any precision ?
If I then store this back onto the database (without alter
Both are in there, not all drivers implement data_sources, and to get column
names for a table you have to first execute
a select * from tbl where 1=0, and then retrieve the column names as
attributes of the statement handle - the oreilly dbi book
tells you how
-Original Message-
From: M
ssues.
Once again,
Thanks to everyone who took time out to help.
Mark.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 18:35
To: 'Jeff Urlwin '; ''Mark Buckle ' '; '[EMAIL PROTECTED] '
Subject: RE: ActivePerl
d
not lo
cate a PPD file for package http://www.xmlproj.com/PPM/DBI-1_20.ppd
C:\DBI-1.20>
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 15:14
To: 'Mark Buckle '; ''''[EMAIL PROTECTED]' ' ' '
Subject:
rsions.
I'm using VC++
Can any-one help at all ?
Thanks in advance.
Mark.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 15:42
To: 'Mark Buckle '; '''[EMAIL PROTECTED]' ' '
Subject: RE: ActivePerl &
Perhaps, not, but then I definitely am going to have to try and build
DBD-Ingres, for which there is no PPM module, not even and out of date one .
:-) .
Mark.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 15:37
To: 'Mark Buckle '
-Original Message-
From: Mark Buckle
Sent: 04 February 2002 13:41
To: 'Berger, Daniel'; 'tzonekev'; [EMAIL PROTECTED]
Subject: RE: ActivePerl & DBI - can't build DBI1.20
I've tried building DBI-1.20 on NT with VC++ 5, and come up with the
following
I've tried building DBI-1.20 on NT with VC++ 5, and come up with the
following error (I've mapped copy to cp BTW) :-
$ perl Makefile.PL
*** You are using a perl with experimental threading enabled!
*** You should be aware that using multiple threads is unstable
*** are should NOT be done in pr
ssage-
From: James.FitzGibbon [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 14:12
To: [EMAIL PROTECTED]
Subject: RE: perl dbi build error on AIX 4.3.3
> -Original Message-
> From: Mark Buckle [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 25, 2002 9:20 AM
> To: '[E
is it for a normal mortal to tweak a particular driver ie
Ingres ?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 13:52
To: Mark Buckle
Cc: '[EMAIL PROTECTED]'
Subject: Re: perl dbi build error on AIX 4.3.3
On Fri, Jan 25, 2002 at 11:00:36A
o:[EMAIL PROTECTED]]
Sent: 25 January 2002 14:12
To: 'Mark Buckle'
Cc: [EMAIL PROTECTED]
Subject: RE: perl dbi build error on AIX 4.3.3
Hello Mark,
I am trying to do the same thing as you right now with some exceptions:
I've installed perl 5.6.1 on an IBM RS6000 running AIX 4.3.2
DBD ingres doesn't appear to support DBI->data_sources($drv), or at least
return any useful info. Is this true ?
Cheers, mark.
-Original Message-
From: Schoenenberger Peter [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 15:06
To: [EMAIL PROTECTED]
Subject: $ENV{NLS_LANG} inside progra
Well, contrary to my expectations DBD Oracle did build and passed all its
tests, with the copied over DBI.so in place.
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 11:01
To: '[EMAIL PROTECTED]'
Subject: perl dbi build error on AIX 4.
The generated DBI.c files are identical, but the DBI.o files are not,
although I suspect this may be normal.
If I copy the working DBI.so over the invalid one, the tests work fine.
However I fear the DBD build may not have this workaround.
-Original Message-
From: Mark Buckle [mailto
Followup :-
The module which works OK :-
-rwxr-xr-x 1 itsmbingres108080 Jan 25 10:33
blib/arch/auto/DBI/DBI.so
The one which doesn't :-
-rwxr-xr-x 1 itsmbingres108030 Jan 25 10:56
blib/arch/auto/DBI/DBI.so
-Original Message-
From: Mark Buckle [mailto:[
cripts could be run, alas--no output ever seen
make: 1254-004 The error code from the last command is 2.
Stop.
--
Checking /usr/opt/perl5/lib/5.00503/aix/DynaLoader.pm line 169 tells me
that the error m
e dbi-users list not dbi-dev
Mark.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 15:24
To: 'Mark Buckle '; '[EMAIL PROTECTED] '
Subject: RE: DBI Handles
Are you talking about mutiple connections, or statement handles?
One wa
Has anyone got DBIx::Recordset working with ingres ?
The tests fall over on the 'Update to NULL...' test.
Cheers, Mark.
-Original Message-----
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2001 14:07
To: [EMAIL PROTECTED]
Subject: DBIx::Recordset queries
I
Is this the correct mailing list for these queries ?
Cheers, Mark
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you ha
mory error when using fetchall_arrayref or
fetchall_ hash ref
On Fri, Nov 16, 2001 at 12:08:14 -0000, Mark Buckle wrote:
> From: Mark Buckle [mailto:[EMAIL PROTECTED]]
> > I'm getting this error, presumably from perl itself :-
> > Out of memory!
> The query I am running here
Followup
The query I am running here should only return a single row,
so it can't be a genuine out of memory error (I've tested the query in isql)
Mark.
-Original Message-----
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 12:04
To: '[EMAIL PROTECTED]
DBI version 1.20
DBD::Ingres 0.30
on AIX 4.3
I'm getting this error, presumably from perl itself :-
Out of memory!
and things seem to die immediately.
Has anyone seen anything like this before.
Cheers, Mark.
> Mark Buckle, Database Administrator, Implementation - Intech Solutio
Or you might find
UPDATE Table1
SET Column1
, Column2 = ( SELECT r.Column1
, r.Column2
FROM Table2 r
WHERE r.Column3 = Table1.Column3
)
WHERE Column3 = Table2.Column3
both legal and more concise.
I'm not sur
Ingres uses the same kind of syntax as given below,
Oracle uses the target column = (nested subquery) syntax.
Gives us plenty of scope for fun when porting Ingres to oracle and vice
versa.
Which is standard ? Doesn't matter, you have to use the syntax your
database(s) support.
Mark
-Or
-Original Message-
From: Mark Buckle
Sent: 24 September 2001 10:41
To: '[EMAIL PROTECTED]'
Subject: FW: Collections of handles
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids' just seems to hold the total number of handles. Presumably if this
information is available then a collection of handles
could be made available. (I'm as
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids' just seems to hold the total number of handles. Presumably if this
information is available then a collection of handles
could be made available. (I'm assumi
Is it possible to connect to a proxy server in a pass-through kind of way,
ie connect from machine A to Machine C via machine B. Both B and C would be
runing dbi-proxy.
This question is basically one of circumventing a firewall on C
> Mark Buckle, Database Administrator, Implementat
54 matches
Mail list logo