I have encountered a problem with the 'extended' support for
objects in DBD::Oracle. Specifically, if $dbh-{ora_objects}
is true, any attempt to fetch a nested table of objects
causes perl to crash with a segmentation fault.
Versions:
OS: SLES10 SP2 (64bit)
Oracle: 10.2.0.4 (64bit)
Perl: 5.10.0
Charles Jardine wrote:
I have encountered a problem with the 'extended' support for
objects in DBD::Oracle. Specifically, if $dbh-{ora_objects}
is true, any attempt to fetch a nested table of objects
causes perl to crash with a segmentation fault.
Versions:
OS: SLES10 SP2 (64bit)
Oracle:
On 07/10/09 11:47, Martin Evans wrote:
Charles Jardine wrote:
I have encountered a problem with the 'extended' support for
objects in DBD::Oracle. Specifically, if $dbh-{ora_objects}
is true, any attempt to fetch a nested table of objects
causes perl to crash with a segmentation fault.
could be a bug
I would try the latest Trunk version of DBD::Oracle there were some
fixes put in there to the Object model way back in July.
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
I will see if I ever get any free time in the near future if I can get
1.24 (the
On 07/10/09 12:23, John Scoles wrote:
could be a bug
I would try the latest Trunk version of DBD::Oracle there were some
fixes put in there to the Object model way back in July.
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
Sadly this doesn't fix the problem. It does,
Charles Jardine wrote:
On 07/10/09 12:23, John Scoles wrote:
could be a bug
I would try the latest Trunk version of DBD::Oracle there were
some fixes put in there to the Object model way back in July.
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
Sadly this
Ok that narrows it down for me nicely.
hopefully I will get some time to look at it soon
might just be a simple var miss match
cheers
John Scoles
Charles Jardine wrote:
On 07/10/09 12:23, John Scoles wrote:
could be a bug
I would try the latest Trunk version of DBD::Oracle there were
John Scoles wrote:
I have been playing with this as of late and the
Short answer is no with a but; and the
Long answer is yes with a maybe.
Right now with OCI (and hence DBD::Oracle as that is what is it written
in) it is not possiable to directly select a xmltype.
you have one of two
Was playing with this as well and I am running into some funny stuff but I
am not sure if it is a DBD issue
Seems it might be an in compatiably between NLS_LANG and the Char you are
trying to read
Try this code again this time add the data to a NCHAR field that may help
DBI version :
John,
Not sure I get what you're saying here. I'm not actually selecting
from a DB table so there's no opportunity for NCHAR.
Anyway, NCHAR is only typically for where you want to run your DB in 8
bit but have a few tables with utf-8 data. We have our whole DB in
utf-8 (which can store
Hi John,
Did you make any sense of this?
Thanks,
Steve
On 30/03/2009, at 10:39 AM, Steve Baldwin wrote:
John,
In case it helps, here is a version of my test script that seems to
correctly handle utf-8 chars for bind_param_inout ...
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI
John,
In case it helps, here is a version of my test script that seems to
correctly handle utf-8 chars for bind_param_inout ...
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI qw();
use DBD::Oracle qw();
use Encode;
print Using DBI $DBI::VERSION and DBD::Oracle $DBD::Oracle::VERSION\n;
John,
I installed this version and it didn't seem to make any difference ...
stbald...@au-stb-mobile:~/dev$ ./utf8.plx
Using DBI 1.605 and DBD::Oracle 1.23
Sym (1) = €
Sym (2) = â¬
I see the same behaviour whether I connect to an 11g or 9i database. I
have the 11g oracle client.
Here's a
I believe this has been has been fixed in the latest trunk version of
DBD::Oracle
I ran the test below and came up with the same values. If you can test
this version of DBD::Oracle
http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-123-RC4.tar
and see if it works for you
cheers
John
DBI version : 1.605
DBD::Oracle version : 1.22
Database: 11.1.0.7 (don't think this matters)
DB Charset : AL32UTF8 (this definitely matters)
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
Consider the following script ...
#!/usr/bin/perl -w
use strict;
use
Thanks for this
As we are moving to 11 we are running into a number of bugs or at least
changes in the way Oracle 11 is working.
I have sorted through the code
and determind that with the SQL you give this call to OCI
OCIAttrGet_parmdp(imp_sth, fbh-parmdp, fbh-dbsize, 0,
OCI_ATTR_DATA_SIZE,
Oh yeah a few more quick questions
1) Which version of 11g are you running?
2) Has it been Patched?
3) can you to a make test and send me the results
Just need the above to have the proper talks with my Oracle chum
cheers
John Scoles
Hi,
We have found some of our code that worked perfectly
Thanks for the quick response John.
We are running 11.1.0.7. As far as I am aware it is up to date
patch-wise. I'm at home at the moment and won't be in the office for
about 3 hours (UTC+11). I'll run the make test then. Do you want me to
run it before the patch, after, or both?
Cheers,
Both would be great.
I am at home today as well with 50kph winds, -24c and 25cm snow-storm in
progress
Seems the 11.1.0.7 for sun has a number of issues.
It would be neat to see if you run into another issues as well I have a
test you could try and run it you have time.
I have attached it all
Hi,
We have found some of our code that worked perfectly well with 9i
started failing when we moved the database to 11g. We are using
DBD::Oracle 1.22.
I have managed to create a very simple test case ...
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI qw();
my $uidpwd = 'usr/p...@db';
Mickautsch, Alfred wrote:
Hello,
when I try to select from a table with a column of sys.xmltype (select * from
c041_dev.xmltest) I get the following error message:
DBD::Oracle::db prepare failed: ORA-22318: input type is not an array type (DBD ERROR:
OCIAttrGet) [for Statement select * from
I have been playing with this as of late and the
Short answer is no with a but; and the
Long answer is yes with a maybe.
Right now with OCI (and hence DBD::Oracle as that is what is it written
in) it is not possiable to directly select a xmltype.
you have one of two options
1) use the XML C
Hello,
when I try to select from a table with a column of sys.xmltype (select * from
c041_dev.xmltest) I get the following error message:
DBD::Oracle::db prepare failed: ORA-22318: input type is not an array type (DBD
ERROR: OCIAttrGet) [for Statement select * from C041_DEV.XMLTEST] at [...].
You might be running into this bug
http://rt.cpan.org//Ticket/Display.html?id=36069
Which is fixed in 1.22 which will be release either today or tomorrow.
cheers John Scoles
Steve Baldwin wrote:
I've just noticed an apparent regression/change_of_behaviour that
affects me.
We do a good deal
I've just noticed an apparent regression/change_of_behaviour that
affects me.
We do a good deal of our DB access accessing tables via private
synonyms. That is, we connect via schema_X which has a private synonym
(lob_table) to schema_Y.lob_table.
On our 'current' machines which have
Hi giedrius,
the ORA-12154 is a typical error when you did not configure your
tnsnames.ora file on the remote host. Can you connect via SQL*Plus?
But i never tried interconnections of different database syseems. So
this mitht not help...
cu, Christian
[EMAIL PROTECTED] schrieb:
Hi all,
I
Hi,
yes, SQL*Plus and DBI @ localhost work fine (no matter TNS or
directly specifying host)
remote system does not have oracle libs, but why should there be any ?
Even postgresql to DBI on localhost works.
Could this relate to something on (probably cleared) environment?
I've
Hi all,
I am desperately trying to link Postgresql with Oracle.
Everything seems to be working except for one thing: I can't manage to
get this baindead thing, called oracle working, where postgresql
client is not on localhost.
Keep in mind that SQL*Plus, DBI test connecting (from dbi_link)
I think I've reported that problem before but we didn't get close
enough to fix the problem, so I'm taking another stab at it.
Environment:
Oracle server is 8.1.7.
Oracle client is 9.2 (same problem with 10g)
DBD::Oracle version 1.18
LANG=en_US.UTF-8
NLS_LANG=.UTF8
When a parameter has the
http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#Oracle_and_Unicode
says roughly that Oracle 8 and Unicode don't mix well. If possible, try
to upgrade the Oracle server to at least 9.2 and use AL32UTF32 as charset.
(I'm not an Oracle expert. I'm just using it occasionally.)
Alexander
On 2007-02-15 18:45:31 +0100, Alexander Foken wrote:
http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#Oracle_and_Unicode
says roughly that Oracle 8 and Unicode don't mix well.
| Oracle 8 client libraries have a number of bugs related to character
| set handling, especially when
Didn't have this error myself but I found something similar
So you might want to try this
changed the line
$DBD::Oracle::VERSION = '1.16';
in Oracle.pm to
$DBD::Oracle::VERSION = '1.06';
Worth a try.
Cheers
Shaw, Gary [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi there,
Has
On Mon, Jan 09, 2006 at 10:50:21AM -0500, John Scoles wrote:
Didn't have this error myself but I found something similar
So you might want to try this
changed the line
$DBD::Oracle::VERSION = '1.16';
in Oracle.pm to
$DBD::Oracle::VERSION = '1.06';
The error message is from a safety
On Thu, Feb 17, 2005 at 02:18:02PM -0600, Raynsford, Kathy W CIV J564KR wrote:
Hello
I'm having problems with the test phase of installing DBD:: oracle
Please read http://www.catb.org/~esr/faqs/smart-questions.html
Included is a script from by session.
I am using Oracle client
Hi,
I run into a strange problem today compiling DBD::Oracle on the newly
installed Oracle 10.1.0.3
the erorr I got was:
gcc -c -I/usr/oracle/rdbms/demo -I/usr/oracle/rdbms/public
-I/usr/oracle/plsql/public
-I/usr/oracle/network/public -I/usr/oracle/rdbms/demo
-I/usr/oracle/plsql/public
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in rdbms/demo and
one in rdbs/public
Can anyone else with access to Oracle 10.1 confirm if they've got
two oci.h files?
[Note that you may not get the
My Solaris setup has only got one oci.h in rdbms/public as does my
pretty much out of the box Windows installation.
Martin
Tim Bunce wrote:
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in
same result :(
D.
On Wed, 2004-11-24 at 16:43, Tim Bunce wrote:
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in rdbms/demo and
one in rdbs/public
Can anyone else with access to Oracle
On Wed, 2004-11-24 at 06:43, Tim Bunce wrote:
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in rdbms/demo and
one in rdbs/public
I have only one, in $ORACLE_HOME/rdbms/public.
Jared
Hi there,
I got a problem installing DBD-Oracle-1.15.
I try to include all Information as described in README:
1)
nmake realclean
2)
perl Makefile.PL -v (see attached log.perl.Makefile.PL)
3)
nmake (see attached nmake.log)
Well, and there I get
fatal error LNK1120: 1 unresolved externals
Hi there,
I got a problem installing DBD-Oracle-1.15.
I try to include all Information as described in README:
1)
nmake realclean
2)
perl Makefile.PL -v (see attached log.perl.Makefile.PL)
3)
nmake (see attached nmake.log)
Well, and there I get
fatal error LNK1120: 1
I downloaded the DBD-Oracle-1.15 module to a Sun 2500 Solaris 9 machine. I
already have installed the latest PERL (5.8.3) and DBI module(1.42). I
also have Oracle 8.1.6 installed. I am able to do the usual perl
Makefile.PL, and make, but make test doesn't seem to run right. It give me
an
I downloaded the DBD-Oracle-1.15 module to a Sun 2500 Solaris 9 machine. I
already have installed the latest PERL (5.8.3) and DBI module(1.42). I
also have Oracle 8.1.6 installed. I am able to do the usual perl
Makefile.PL, and make, but make test doesn't seem to run right. It give me
an
Hello all,
I am trying to run a perl script that from one host has to access a database
running on another host. I am encountering some troubels here, that I have a
workaround for right now, but I'd like to have the opinion of the experts on
the list anyway.
The situation: Host A runs Oracle
Sounds to me like you need to install the oracle client and then
recompile DBD::Oracle.
[EMAIL PROTECTED] wrote:
Hello all,
I am trying to run a perl script that from one host has to access a database
running on another host. I am encountering some troubels here, that I have a
workaround for
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
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 dbms_output_get
in Oracle.pm, so that the return status from dbms_output.get_line is '0
'
Put the oracle directory where libclntsh.so is located in the
LD_LIBRARY_PATH.
hth, Dave
On May 1, Eric Ngantchjon scribed:
How can I solve the problem below ?
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle..so'
for module DBD::Oracle: ld.so.1:
Hi everyone,
I'm trying to run the test program to connect to Oracle database, but it
gave me the following message:
Out of memory during large request for 1073745920 bytes at
/opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1/DBD/Oracle.pm line 262.
Does any one know what causing this?
The query
Which configuration and version(s) of used SW?
Please... :-)
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 5:48 PM
To: [EMAIL PROTECTED]
Subject: Does any one know what cause this DBD::Oracle problem?
Hi everyone,
I'm trying
Alan Kong wrote:
Hi DBI experts,
I'm trying to install oracle driver, DBD:Oracle on a HP900 for Oracle 8.1.7.
DBI-1.18 is installed successfully, but there is problem on 'make' step when
installing DBD::Oracle, where the error message stated that nbeq8 cannot be
found. Does anyone have
, Inc
Ann Arbor
-Original Message-
From: Baxter, Lincoln [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 3:46 PM
To: 'Peterson, Ted'; '[EMAIL PROTECTED]'
Subject: RE: HP-UX 11.0, DBD::Oracle problem
It looks like it cann't find the path to $ORACLE_HOME/lib libraries.
Try setting
I'd greatly appreciate a clue about this problem; I've been wandering about
the mail archives, and don't see mention of a solution.
I've built a non-threaded perl5.6.0, adding -lcl and -lpthread to config.sh,
then built DBI 1.14, then built DBD::Oracle 1.06 with the two patches to the
Makefile
PROTECTED]'
Subject: HP-UX 11.0, DBD::Oracle problem
I'd greatly appreciate a clue about this problem; I've been wandering about
the mail archives, and don't see mention of a solution.
I've built a non-threaded perl5.6.0, adding -lcl and -lpthread to config.sh,
then built DBI 1.14, then built DBD
Ted,
dld.sl is trying to load libwtc8.sl because libclntsh.sl (Oracle's client
library) was linked with it.
My guess is your LD_LIBRARY_PATH isn't set correctly. It should contain
$ORACLE_HOME/lib
Hope this helps,
Mark
Peterson, Ted wrote:
I'd greatly appreciate a clue about this problem;
On Mon, Apr 02, 2001 at 12:22:49PM -0700, Michael A. Chase wrote:
DBI 1.15 built, tested, and installed cleanly in WinNT with MingW32 gcc
2.95.2.
When I ran the DBD::Oracle tests t/plslq.t failed at test 54. The test
failed at the same point both before and after I rebuilt DBD::Oracle
Hi,
We are working with a
HP-UX iupiter B.11.00 U 9000/800 557706567 unlimited-user license
We have installed
Oracle 8.1.6.
and perl5.6.0
We are trying to connect to database with a script perl. We need a DBI interface and a
DBD driver for it, and we got DBI-1.15 installed succesfully and
First of all
Ilya, Jonathan thanks for the hint on the C Compiler.
I have DBI 1.14 DBD Oracle 1.06 installed on a Solaris.
When I try to execute my perl scripts I get the followin error:
$ nsperl miprueba.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains:
To: [EMAIL PROTECTED]
Sent: 03/07/2001 5:36 AM
Subject: DBD Oracle Problem
First of all
Ilya, Jonathan thanks for the hint on the C Compiler.
I have DBI 1.14 DBD Oracle 1.06 installed on a Solaris.
When I try to execute my perl scripts I get the followin error:
$ nsperl miprueba.pl
install_driver(O
and he'll eat fish for an age.
- Original Message -
From: "P B" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, February 18, 2001 10:19 PM
Subject: RE: DBI with DBD::Oracle Problem #2
Okay, after some work on this, I'm getting this problem co
: "P B" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 19, 2001 6:31 AM
Subject: Re: DBI with DBD::Oracle Problem #2
If I have both the undef and the disconnect() I get the message:
Can't call method "disconnect" on an undefined value at dbtest.pl line 19.
only have a connect string and no prepares,
fetches, or anything else in the code.
From: "Michael A. Chase" [EMAIL PROTECTED]
To: "P B" [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: DBI with DBD::Oracle Problem #2
Date: Mon, 19 Feb 2001 11:22:14 -0800
This happens even if y
62 matches
Mail list logo