and some alternatives.
at Makefile.PL line 1039.
[EMAIL PROTECTED]
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
- is system(false), 18, 'system false should return 256';
- is system(true), 0, 'system true should return 0';
+ is system(exit 1;), 18, 'system exit 1; should return 256';
+ is system(exit 0;),0, 'system exit 0; should return 0';
}
--
Charles Jardine - Computing
and some alternatives.
at Makefile.PL line 1039.
[EMAIL PROTECTED]
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
Instant Client branches
swapping around.
[snip]
Swap the XE and IC tests over (as in attached patch) and it builds
successfully again for me (on Linux 10201instant, 10201xe, 10201full,
10104instant, 9207full).
This patch makes my build on Solaris 8 10201instant work again.
--
Charles
'b=null', as is should. 'b=null' can
never be true.
This is not Oracle specific. It is covered under 'NULL values' in
the DBI pod.
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
. The writer of a program
using such a driver has to care about the utf8 flag, since
strings which compare equal in perl, but differ in the setting
of the flag, will produce different results when processed by
the DBD. This ought not to be the way of the future.
--
Charles Jardine - Computing Service
installed DBD::Oracle to do this
for you.
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
by NULL, both in PL/SQL and
in SQL.
I strong agree with Tim's position before he teetered.
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
long long)*rsizep, oci_status_name(stat)),stat \
: stat
/* added by lab */
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 14/01/10 12:19, Charles Jardine wrote:
On 12/01/10 12:07, John Scoles wrote:
Ok third time is a Charm
The Third RC of the beer edition of DBD::Oracle 1.24 can be found at
http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.24-RC3.tar
This round has a few little patches from Martin
the '
NLS_CHARACTERSET and
UTF8
NLS_NCHAR_CHARACTERSET
AL16UTF16
setting of your Oralcle DB you are testing on
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 14/01/10 12:19, Charles Jardine wrote:
My environment is Linux x86-64, Perl 5.10.1 (64 bit), DBI 1.609,
Oracle 10.2.0.4.2 (64 bit). Database charset UTF8, national
charset AL16UTF16
Three things:
[ snip ]
2. Back in early October, I reported a problem with the support for
objects
is every going to need a size_t and in any
case it has a max size of OCI_NLS_MAXBUFSZ (100 in Instant Client 11.1
for Linux X86).
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 27/01/10 17:38, Martin Evans wrote:
Charles Jardine wrote:
On 27/01/10 15:52, Martin Evans wrote:
Hi,
I was asked to enable ora_verbose and send a trace a few days ago.
I'm getting a segfault with DBD::Oracle when ora_verbose or dbd_verbose
is set to 15 in the connect method call
, national
charset AL16UTF16.
RC5 compiles without warnings and passes all its tests, including
the regression tests for my object patches. I have run some sample
work at trace level 15 - there are no segfaults.
In short, I can't find anything wrong with it.
--
Charles Jardine - Computing Service
anything
It still compiles without warnings and passes all its tests.
if is a change to precision for OCIDateTimeToText to 6 instead of 0 for
varrays of timestamps
needed to conduct a large scale experiment of some sort
cheers
John Scoles
Charles Jardine wrote:
On 28/01/10 15:59, John
Manual
Large objects (LOBs) are not supported in comparison conditions.
However, you can use PL/SQL programs for comparisons on CLOB data.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
the bequeather
or a TNS connection.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 03/11/10 19:16, Brian Phillips wrote:
On Wed, Nov 3, 2010 at 9:55 AM, Charles Jardine c...@cam.ac.uk wrote:
I simply do not see this effect. The following program:
#!/usr/local/bin/perl -w
use DBI;
my $dbh = DBI-connect(dbi:Oracle:, oralogin) or die Failed\n;
$| = 1;
sleep 1, print
reasonable/useful way.
An option could be provided to restore the current unreasonable way.
I can say whether a workaround would be a good idea without understanding
exactly what the problem is. I can't reproduce the original poster's
problem, and I don't know why.
--
Charles Jardine - Computing
.
# prepare the stored procedure
if ($sth = $DBH-prepare( $record )){
print $LOG prepared: $HoH{$filename}{'full_filename'} \n;
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
,
-AMOUNT = 777.666,
+AMOUNT = 777.875,
};
is_deeply($obj-attr_hash, $expected_hash, 'DBD::Oracle::Object-attr_hash');
is_deeply($obj-attr, $expected_hash, 'DBD::Oracle::Object-attr');
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.uk
with my version of the code. This intrigues me.
I would expect non-final types to be handled worse, not better.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 12/12/11 16:13, Martin J. Evans wrote:
On 09/12/11 18:02, Charles Jardine wrote:
On 09/12/11 14:01, Martin J. Evans wrote:
Hi,
If anyone is around who wrote or has worked on the object/collections
support in DBD::Oracle I'd greatly appreciate it if you could take a
quick look
On 12/12/11 20:24, Martin J. Evans wrote:
On 12/12/2011 18:15, Charles Jardine wrote:
On 12/12/11 16:13, Martin J. Evans wrote:
On 09/12/11 18:02, Charles Jardine wrote:
On 09/12/11 14:01, Martin J. Evans wrote:
Hi,
If anyone is around who wrote or has worked on the object/collections
some
time to convert, or seek advice.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 10/02/12 14:56, H.Merijn Brand wrote:
On Fri, 10 Feb 2012 14:30:03 +, Charles Jardine c...@cam.ac.uk
wrote:
On 10/02/12 13:32, H.Merijn Brand wrote:
Preparing a new database machine ...
Do I need to worry?
t/10general.t 1/30
# Failed test 'system exit 1 should
don't get.
$obj is not a string. It is an object of a class which has a
stringify operator. $obj is a string, because ... stringifies.
It is not at all clear how the DBI should take a copy of an object.
I think this is a case of user error.
--
Charles Jardine - Computing Service, University
); }
and it printed
Object
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
On 16/08/12 16:37, Martin J. Evans wrote:
On 16/08/12 16:13, Charles Jardine wrote:
I thought it might be interesting to see what DBD::Oracle does.
I ran
use strict;
use DBI;
my $dbh =
DBI-connect(dbi:Oracle:, '', '');
my $obj = new Object();
my $sql = q(SELECT ? AS result from dual);
my
to the database. It is possible use virtual views to
monitor the database and ALTER SYSTEM commands to change its state. However
it is not possible to select from any table. SELECT 1 FROM DUAL will fail.
I would like to see $dbh-ping to continue to return a true values in cases
like this.
--
Charles Jardine
. The pre-created perl statement handle
should be left alone. It may me used in a subsequent execute of the
same statement with different bind values. The value returned to
perl should be undef, not a reference to the magic statement handle.
--
Charles Jardine - Computing Service, University
On 15/01/13 11:20, Martin J. Evans wrote:
On 15/01/13 10:56, Charles Jardine wrote:
On 11/01/13 16:04, Martin J. Evans wrote:
I am using DBD::Oracle and calling a procedure which returns a reference
cursor. However, sometimes the reference cursor is not opened and only
the procedure knows
On 15/01/13 16:01, Martin J. Evans wrote:
On 15/01/13 15:04, Charles Jardine wrote:
Are you saying that, in the case of a NULL variable, the indicator
variable does not indicate nullity?
I am saying when you have:
procedure fred(pcur OUT SYS_REFCURSOR) as
begin
pcur := NULL;
end
if your time.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
35 matches
Mail list logo