sco...@pythian.com wrote:
Thanks Martin I have added it to the Trunk
If you can test it that would be great
here is the file
http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL
Cheers John Scoles
Tested fine.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
FYI
Thanks Martin
:)
cheers
sco...@pythian.com wrote:
Thanks Martin I have added it to the Trunk
If you can test it that would be great
here is the file
http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL
Cheers John Scoles
Tested fine.
Martin
--
Martin J. Evans
Easysoft Limited
: Permission denied at Makefile.PL line 1516.
print() on closed filehandle FH at Makefile.PL line 1517.
Looks like you are trying to install DBD::Oracle while logged on as oracle.
You probably need to be root.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
I worked on installing DBD-Oracle 1.22 on Solaris10 with Perl 5.8.4 and
DBI 1.6.0.7, but I never succeeded. I found a posting by James
McCullars at the University of Alabama in Huntsville back in August 2008
saying that he could not install it either. The command, make test,
produced multiple
I am trying to install the DBD::Oracle 1.22 for Perl 5 on a Solaris 10
system; I have already successfully installed the DBI. The Oracle
database is version 10.2.0.3 and the version of Perl is 5.8.4:
Output of Perl -V:
Summary of my perl5 (revision 5 version 8 subversion 4) configuration
I am trying to install the DBD::Oracle 1.22 for Perl 5 on a Solaris 10
system; I have already successfully installed the DBI. The Oracle
database is version 10.2.0.3 and the version of Perl is 5.8.4:
Output of Perl -V:
Summary of my perl5 (revision 5 version 8 subversion 4) configuration
can patch you dbd::oracle
it is oci8.c
on line #2628
change
/*the simple types*/
case 1: /* VARCHAR2 */
avg_width = fbh-dbsize / 2;
/* FALLTHRU */
to this
/*the simple types*/
case 1:/* VARCHAR2 */
if (fbh-dbsize == 0){
fbh-dbsize=32;
}
avg_width = fbh-dbsize / 2
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';
my $dbh = DBI-connect('dbi:Oracle:', $uidpwd
John Scoles
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
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';
my $dbh = DBI-connect('dbi:Oracle:', $uidpwd, '', {RaiseError = 1
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
Hi. I am hoping someone can look over this install info and tell me if it is
all ok?
I am having some worries with a new install of fedora 10.
I also installed oracle 11.1.0.7.
I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD
and Oracle for many many years.
I have
t/31lob_extended (which coincidentally I wrote
it appears) to fall over with a seg fault. I think the problem is that
DBD::Oracle should NOT retrieve multiple rows at a time if the table
contains a lob and ora_auto_lobs is disabled.
[mar...@db DBD-Oracle-1.22]$ perl -Iblib/lib -Iblib/arch
t
sees a lob. That fools DBD::Oracle into thinking the result-set
has a long or long raw and so it forces a fetch 1 row at a time. Now,
I'm not suggesting this is the solution but that is what I've done here
temporarily and it may help you work out a better way of doing it.
Thanks for looking
.
BTW, this is DBD::Oracle 1.22.
I have a simple table in Oracle XE (but the version does not seem to
matter) with integers in it. There are 25538 rows. I have function that
looks like this:
FUNCTION f_xxx RETURN SYS_REFCURSOR AS
l_cursor SYS_REFCURSOR;
BEGIN
OPEN l_cursor
like some help with as I
have now come unstuck trying to understand what the code in oci8.c is
supposed to do. I have one table and 2 ways to select the same data
from it but one is fast and the other is really slow but I'm stuck
with the latter.
BTW, this is DBD::Oracle 1.22.
I have a simple
situation I would dearly like some help with as I
have now come unstuck trying to understand what the code in oci8.c is
supposed to do. I have one table and 2 ways to select the same data
from it but one is fast and the other is really slow but I'm stuck
with the latter.
BTW, this is DBD::Oracle 1.22
to understand what the code in oci8.c is
supposed to do. I have one table and 2 ways to select the same data
from it but one is fast and the other is really slow but I'm stuck
with the latter.
BTW, this is DBD::Oracle 1.22.
I have a simple table in Oracle XE (but the version does not seem
over with a seg fault. I think the problem is that
DBD::Oracle should NOT retrieve multiple rows at a time if the table
contains a lob and ora_auto_lobs is disabled.
[mar...@db DBD-Oracle-1.22]$ perl -Iblib/lib -Iblib/arch t/31lob_extended.t
1..31
ok 1 - created test table
ok 2 - created test
it appears) to fall over with a seg fault. I think the problem is that
DBD::Oracle should NOT retrieve multiple rows at a time if the table
contains a lob and ora_auto_lobs is disabled.
[mar...@db DBD-Oracle-1.22]$ perl -Iblib/lib -Iblib/arch t/31lob_extended.t
1..31
ok 1 - created test table
it against
1.16 DBD::Oracle. This trick might work.
cheers
John Scoles
Eric Pancer wrote:
Greetings,
I'm working with RHEL 4 and having some issues compiling DBD-Oracle
1.16. I'm guessing this may be due to using an older version of
DBD-Oracle, but I cannot upgrade to DBI version 1.51 at this point
Try any version instantclient 10 that should work.
There is no benefit in using the 11 instant client with any DBD::Oracle
as a matter of fact there are a still few bugs in 11ic the DBD::Oracle
hits and with 11ic you cannot connect to an Oracle db earlier than 10g.
cheers
Eric Pancer wrote
.
One last hope it to get the Makefile.PL from 1.17 and run it against 1.16
DBD::Oracle. This trick might work.
Thanks John.
Well, it turns out that isn't the only problem I'm bumping into now. I
grabbed DBD-Oracle-1.17 and now I get this:
$ sha1sum Makefile.PL
Greetings,
I'm working with RHEL 4 and having some issues compiling DBD-Oracle
1.16. I'm guessing this may be due to using an older version of
DBD-Oracle, but I cannot upgrade to DBI version 1.51 at this point.
So, here's the details:
$ uname -a
Linux example.org 2.6.9-55.ELsmp #1 SMP Fri Apr
On Wed, 2008-12-17 at 16:08 +0100, pmonsch...@groupe-casino.fr wrote:
}
My environment is correct :
ORACLE_HOME is correctly set and point to and OCI oracle folder
(10gR2.4 64bit)
This sentence is somewhat confusing.
What exactly is the value of $ORACLE_HOME ?
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 executed : perl Makefile.PL it is reporting this warning : Can't
find sqlplus. Pity, it would have helped.
I found that this problem is because of bug in function in Makefile.PL
sub find_bin{
use filetest 'access';
my $bin = shift;
my $path_sep = $Config{path_sep};
-Message d'origine-
De : Martin Evans [mailto:martin.ev...@easysoft.com]
Envoyé : mercredi 17 décembre 2008 16:19
À : dbi-users@perl.org
Objet : Re: Error in DBD::Oracle (1.22) Makefile.PL with filetest
pmonsch...@groupe-casino.fr wrote:
Hello
When I executed : perl
I've just given an answer to this question at StackOverflow.com:
http://stackoverflow.com/questions/370425/perl-oracle-multithreaded
If you disagree with what I said (Tim, or anyone involved with DBD::Oracle),
either correct me on SO, or add your own answer, or just let me know and
I'll correct
on
the matter.
The other problems you are encountering are due to the user who is
running the test not having sufficient privs on the DB.
Once I get access to an 11g EE box I might be able to look into it
deeper.
cheerrs
[EMAIL PROTECTED] wrote:
Hi,
I am trying to install DBD::Oracle
to an 11g EE box I might be able to look into it deeper.
cheerrs
[EMAIL PROTECTED] wrote:
Hi,
I am trying to install DBD::Oracle against perl v5.8.8. I am
running Oracle Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 on Ubuntu 8.04. The perl Makefile.pl and make seemed to
work fine. 'make
Hi,
I am trying to install DBD::Oracle against perl v5.8.8. I am
running Oracle Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 on Ubuntu 8.04. The perl Makefile.pl and make seemed to
work fine. 'make test' however fails against t/26exe_array. I see some
other errors in the output
. But my
cgi-perl applications do not work and I get the following error in log file
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.1/sun4-solaris/auto/DBD/Oracle/Oracle.so
' for module DBD::Oracle: ld.so.1: /usr/bin/perl: fatal: relocation error:
file
/usr/local/lib
with DBD::Oracle as
DBD::mysql has (appended in the connect DSN) ?
Thanks!
Patrick
John,
Hi! DBD::mysql uses mysql_auto_reconnect to connect back to MySQL if the
connection drops
$dbh= DBI-connect('DBI:mysql:test:mysql_auto_reconnect=1', $foo, $fee)...;
or of course
$dbh
On Tue, Nov 11, 2008 at 11:27:59AM -0500, Patrick Galbraith wrote:
John,
Hi! DBD::mysql uses mysql_auto_reconnect to connect back to MySQL if the
connection drops
$dbh= DBI-connect('DBI:mysql:test:mysql_auto_reconnect=1', $foo, $fee)...;
or of course
$dbh-{mysql_auto_reconnect};
In
I echo Tim's comments. We looked into implementing auto reconnect for
our applications (e.g. in the case of the DB going down) and unless you
have a *very* simple scenario it was just too much work to save and
restore state.
For example, you could lose the connection between a -prepare and an
Hi there,
Is there the equivalent of an auto-reconnect with DBD::Oracle as
DBD::mysql has (appended in the connect DSN) ?
Thanks!
Patrick
Not that I am aware of.
Is auto-reconnect a specific MYSQL command of some sort or is a PERL
base command or some sort?
Can you give me an example of how it is used?
cheers
John Scoles
Patrick Galbraith wrote:
Hi there,
Is there the equivalent of an auto-reconnect with DBD::Oracle
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
,OCI_HTYPE_ERROR)=SUCCESS
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: John D Parker [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Thursday, November 6, 2008 5:53:14 AM
Subject: Re: Fw: DBD::Oracle installation issues
Most likely you have a US7ASCII as your
PROTECTED] [EMAIL PROTECTED]
*To:* John D Parker [EMAIL PROTECTED]
*Cc:* dbi-users@perl.org
*Sent:* Thursday, November 6, 2008 5:53:14 AM
*Subject:* Re: Fw: DBD::Oracle installation issues
Most likely you have a US7ASCII as your default cahset in your DB while
Perl is trying to force in something
This is perl, v5.8.8 built for i686-linux
Oracle client 9.2.0.4.0
Oracle db 10.1.0.4.0 64 bit
Red Hat Enterprise Linux ES release 3 (Taroon Update 9)
Linux my.host.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 23:35:44 EST 2005 i686
i686 i386 GNU/Linux
DBD::Oracle 1.22
DBI 1.607
I've seen
to fix
the test in your case
This is perl, v5.8.8 built for i686-linux
Oracle client 9.2.0.4.0
Oracle db 10.1.0.4.0 64 bit
Red Hat Enterprise Linux ES release 3 (Taroon Update 9)
Linux my.host.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 23:35:44 EST 2005
i686 i686 i386 GNU/Linux
DBD::Oracle 1.22
9)
Linux my.host.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 23:35:44 EST
2005 i686 i686 i386 GNU/Linux
DBD::Oracle 1.22
DBI 1.607
Every thing works up to test and then...
PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/01base
not care about
the UTF8 stuff anyway.
if you can run this short program
#!/usr/local/bin/perl
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbh =$dbh =
DBI-connect('dbi:Oracle:','user_name','password',{ora_verbose=7});
and send it back to me I will have a closer look at the you system
On Thu, Oct 30, 2008 at 09:20:07PM +, Martin J. Evans wrote:
Martin Gainty wrote:
I do however, think
that with DBD::Oracle it is annoying to have to say bind this as a blob and
then (when it is a select) to have it automatically subject to LongReadLen
and LongTruncOk
Tim Bunce wrote:
On Thu, Oct 30, 2008 at 09:20:07PM +, Martin J. Evans wrote:
I do however, think
that with DBD::Oracle it is annoying to have to say bind this as a blob and
then (when it is a select) to have it automatically subject to LongReadLen
and LongTruncOk as these introduce
bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
This is a disaster to all portability!
My scripts *ALL* are portable across all databases, and ORA_BLOB is
only exported by DBD::Oracle, so in portable scripts I need
Having a look at the DBD::ORacle code
trying to make
$sth-bind_param(:p1, foo\nbar, { TYPE= SQL_BLOB });
work so if would be portable across drivers.
and the key problem I am running into of course it that the TYPE=
SQL_BLOB will send 30 into bind rather that say the key value 'SQL_BLOB
OK anoter look at it how does this grab everyone
use DBI;
use DBD::Oracle qw(:sql_types);
my $dbh = DBI-connect('', '','', {RaiseError = 1, PrintError = 0});
my $stu = $dbh-prepare ('update w_testsetw_test = :p2where
c_test =:p1 and v_test = 1');
$stu-bind_param(:p1,1
On Fri, Oct 31, 2008 at 12:16:25PM -0400, John Scoles wrote:
Having a look at the DBD::ORacle code
trying to make
$sth-bind_param(:p1, foo\nbar, { TYPE= SQL_BLOB });
work so if would be portable across drivers.
and the key problem I am running into of course it that the TYPE
On Fri, Oct 31, 2008 at 12:16:25PM -0400, John Scoles wrote:
Having a look at the DBD::ORacle code
trying to make
$sth-bind_param(:p1, foo\nbar, { TYPE= SQL_BLOB });
work so if would be portable across drivers.
and the key problem I am running into of course it that the TYPE=
SQL_BLOB
, Oct 31, 2008 at 12:16:25PM -0400, John Scoles wrote:
Having a look at the DBD::ORacle code
trying to make
$sth-bind_param(:p1, foo\nbar, { TYPE= SQL_BLOB });
work so if would be portable across drivers.
and the key problem I am running into of course it that the TYPE=
SQL_BLOB will send 30
(w_test blob);
);
$dbh-commit;
my $stu = $dbh-prepare (qq;
update w_test
setw_test = ?
where c_test = ?
and v_test = 1;
);
$stu-execute (foo\nbar, 1);
$stu-finish;
$dbh-commit;
--8---
$ perl w-test.pl
DBD::Oracle::st execute failed: ORA-01465: invalid hex number (DBD
On Thu, Oct 30, 2008 at 8:35 AM, H.Merijn Brand [EMAIL PROTECTED] wrote:
I don't understand what the error I get has to do with the executed code.
Can someone enlighten me?
[...]
$dbh-do (qq;
create table w_test (
c_test numeric (9),
v_test numeric (4),
s_test
Ok looks like you need to use bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
The code below works
#!/usr/local/bin/perl
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbname = 'first10g';
my $dbuser = 'tbo';
my $dbpass
On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles [EMAIL PROTECTED]
wrote:
Ok looks like you need to use bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
This is a disaster to all portability!
My scripts *ALL
On Thu Oct 30, 2008 at 02:34:55PM +0100, H.Merijn Brand wrote:
On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles [EMAIL PROTECTED]
wrote:
Ok looks like you need to use bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type
::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
This is a disaster to all portability!
My scripts *ALL* are portable across all databases, and ORA_BLOB is
only exported by DBD::Oracle, so in portable scripts I need to hardcode
those
Scoles [EMAIL PROTECTED]
wrote:
Ok looks like you need to use bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
This is a disaster to all portability!
My scripts *ALL* are portable across all databases
with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu-bind_param(:p1,foo\nbar,{ ora_type = ORA_BLOB });
This is a disaster to all portability!
My scripts *ALL* are portable across all databases, and ORA_BLOB is
only exported by DBD::Oracle, so in portable scripts I need to hardcode
Again Tim and his wisdom of the ages comes to the rescue.
A quick look at DBD::ORacle and his suggestion will take only a few
seconds to do.
Looks like a patch coming up in the AM.
cheers
John Scoles
Tim Bunce wrote:
On Thu, Oct 30, 2008 at 10:43:22AM -0400, John Scoles wrote:
I
On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles [EMAIL PROTECTED]
wrote:
Again Tim and his wisdom of the ages comes to the rescue.
A quick look at DBD::ORacle and his suggestion will take only a few
seconds to do.
Well, it was like I suggested, but it still does not remove the need
]; [EMAIL PROTECTED]; dbi-users@perl.org
Subject: Re: DBD::Oracle + BLOB
On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles [EMAIL PROTECTED]
wrote:
Again Tim and his wisdom of the ages comes to the rescue.
A quick look at DBD::ORacle and his suggestion will take only a few
seconds to do
On Thu, Oct 30, 2008 at 09:00:38PM +0100, H.Merijn Brand wrote:
On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles [EMAIL PROTECTED]
wrote:
Again Tim and his wisdom of the ages comes to the rescue.
A quick look at DBD::ORacle and his suggestion will take only a few
seconds to do
setw_test = ?
where c_test = ?
and v_test = 1;
);
$stu-execute (foo\nbar, 1);
--8--
Will fail, because the blob dat does not know about its type, In Oracle
this will give:
DBD::Oracle::st execute failed: ORA-01465: invalid hex number (DBD ERROR: error
possibly near
maintainers but even though I look after
DBD::ODBC currently, I mostly use DBD::Oracle in the work I'm doing
currently. Previous to that we attempted to make our app work with DB2,
mysql, Oracle and ODBC (before we settled on a database) and failed
horribly. Most of our app would work with most DBDs
Hi,
I have a quick question . I have an Oracle 10g running on a Sun 9.5 .
I Want to access the Database from perl . I am aware that I need DBI
and DBD module to interface it . However do I also need to install and
configure the Oracle client 'OLITE_10.3.0.2.0_SOLARIS' (Oracle
Database Lite 10g
Yes you have to have an Oracle client to get it to DBI DBD to work
Most people these days are using the Instant Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
I do not really know olite client light I guess it would worded
cheers
John Scoles
Hi,
I have a
# cpan DBD::Oracle
...
Remember to actually *READ* the README file! Especially if you have
any problems.
...
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
...
t
Which version of DBD:Oracle did you try and install.
You best bet is to get the latest version from activestate
This problem might mean that you have no client installed on you box.
Make sure you have an Oracle client on you box and you compiled
DBD::Oracle against it
Cheers
John Scoles
Dist,
When I am trying to install DBD Oracle on W2k3 Sp2 , perl 5.8.8
Its giving me following Error
unable to realloc 8171421 bytes
This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information
characters in you SQL.
cheers
Mickautsch, Alfred wrote:
Hello,
with ActivePerl 5.10.0 build 1004, DBI 1.607, DBD::Oracle 1.21 and Oracle
10.2.0.1.0 in a PAR-archived executable on a Win XP machine I get the following
error message:
DBD::Oracle::db column_info failed: ORA-01008: not all variables
Hi John!
Installing DBD::Oracle 1.19 was successful.
Thanks for your help!
Best regards,
Roman Sotnikov
Head of technological dept. JSC URSA Bank.
tel: +007 383 227-81-26 ext. 15316
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 6:03
Hi,
I try to install DBD::Oracle 1.22 on RHEL4-U4-x86_64-AS Red Hat.
Version of Oracle cleint is: 9.2.0.7
Perl version is:
[EMAIL PROTECTED] DBD-Oracle-1.22]# perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
Platform:
osname=linux, osvers=2.6.9-22.18.bz155725
The Oracle client you are using is most likely not fully patched as it
is missing
OCIXMLTypeCreateFromSrc
though this is odd as OCI9 should have the above. This might be true of
64bit 9.2 never found it with 32 bit though.
You can do one of few things
1) use DBD::Oracle 1.20 or 1.19
2
I have blob that is stored in an Oracle table that, with a chunk size of
4096 bytes, requires 2 chunks. The second chunk however is one byte long
and contains a zero (ASCII 48). The data is read in using ora_lob_read,
and so if you follow the method in documentation for DBD::Oracle, i.e
however is one byte
long and contains a zero (ASCII 48). The data is read in using
ora_lob_read, and so if you follow the method in documentation for
DBD::Oracle, i.e., something like
while( my $data = $dbh-ora_lob_read( $char_locator, $offset,
$chunk_size ) ) {
print STDOUT $data
and 11.1.0.6
client, both 32-bit and 64-bit, with DBD-Oracle-1.22. DBD-Oracle 1.21
works fine however.
Interestingly I have another complex query (a function returning a
sys_refcursor) that barfs with an ORA-24347 using DBD-Oracle 1.21 and
client 11.1.0.6 or 10.1.0.3 (9.2.0.8 database
: 9.2.0.8 (WE8ISO8859P15) and/or 10.2.0.2.0 (AL32UTF8)
and a 32-bit Centos 5.2 box:
Perl: 5.8.8
DBI: perl-DBI-1.605-1.el5.rf
Oracle client: 11.1.0.6
Oracle database 9.2.0.8 (WE8ISO8859P15) and/or 10.2.0.2.0 (AL32UTF8)
With DBD-Oracle 1.21, the below works fine. with DBD-Oracle-1.22 it
errors
Hi,
at /cgi-bin/NEI/ibank_lib.dbi line 24
install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/
site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBD/Oracle/Oracle.so' for
module DBD::Oracle: ld.so.1: perl: fatal:
culprit =
/app/oracle/product/10.2.0/db/lib/libclntsh.so
of
DBD::ORacle are a little off when it comes to using binary data with utf8.
can you run this on you oracle box
select * from nls_database_parameters
and send me the results so I can see what you charset is
cheers
John Scoles
Okay, I revised my code for test thusly:
my @pkt
Steve Baldwin wrote:
I wonder what we have different. Here's a run I just did that shows
Oracle version, DBI version, and DBD::Oracle version. The Oracle client
is 11.1 full (i.e. not Instant) ...
[EMAIL PROTECTED] dev][2]$ sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 11.1.0.6.0 - Production
Tofigh, Mike (NIH/NEI) [C] wrote:
Here is the error I get when I run the application
at /cgi-bin/NEI/ibank_lib.dbi line 24
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1
Here is the error I get when I run the application
at /cgi-bin/NEI/ibank_lib.dbi line 24
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: perl: fatal:
/app/oracle
but it gets changed to what you see above somehow)
When I run make I see the following:
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h
Well I am running my code against a 10.2 DB looks like you are using 9.2??
perhaps you patch-set for you 9.2 db is not up to date??
cheers
John Scoles
Steve Baldwin wrote:
I wonder what we have different. Here's a run I just did that shows
Oracle version, DBI version, and DBD::Oracle version
my code against a 10.2 DB looks like you are using 9.2??
perhaps you patch-set for you 9.2 db is not up to date??
cheers
John Scoles
Steve Baldwin wrote:
I wonder what we have different. Here's a run I just did that shows
Oracle version, DBI version, and DBD::Oracle version
however appear to still be broken. Here is an extract from a
level 3 trace ...
DBI::db=HASH(0x61b8350) trace level set to 0x0/3 (DBI @
0x0/47120086204416) in DBI 1.52-ithread (pid 27618)
- prepare for DBD::Oracle::db (DBI::db=HASH(0x61a64d0)~0x61b8350 '
INSERT
I wonder what we have different. Here's a run I just did that shows
Oracle version, DBI version, and DBD::Oracle version. The Oracle client
is 11.1 full (i.e. not Instant) ...
[EMAIL PROTECTED] dev][2]$ sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Sep 10 05:47:04
Hello:
I have project in my hand that I am not getting anywhere with it for
past few months.
I have CGI application runing using appache, DBD::oracle, DBI, and
Perl 5.8, in Solaris 8, running with ORACLE 9i
I have upgrade ORACLE 9i to oracle 10g and solaris OS to Solaris 10 64
bits
Tofigh, Mike (NIH/NEI) [C] wrote:
Hello:
I have project in my hand that I am not getting anywhere with it for
past few months.
I have CGI application runing using appache, DBD::oracle, DBI, and
Perl 5.8, in Solaris 8, running with ORACLE 9i
I have upgrade ORACLE 9i to oracle 10g
is that CLOB's appear to be OK.
BLOB's however appear to still be broken. Here is an extract from a
level 3 trace ...
DBI::db=HASH(0x61b8350) trace level set to 0x0/3 (DBI @
0x0/47120086204416) in DBI 1.52-ithread (pid 27618)
- prepare for DBD::Oracle::db (DBI::db=HASH(0x61a64d0)~0x61b8350
I would have to agree with Martin that the you should really try to get
DBD::Oracle working on you 64 bit box I am sure if you uwe the 32 bit
instant client it will work for you .
Check some of the previous posts on this lits lots of people use the
DBD::ORacle on 64 bit Solaris boxes
Tofigh, Mike (NIH/NEI) [C] wrote:
where can I get instance client lib from
http://www.oracle.com/technology/tech/oci/instantclient/index.html
What it does not work is the dbd::oracle in the perl program complaint about
can not find. Oracle lib
I will check it and send you the info when I
where can I get instance client lib from
What it does not work is the dbd::oracle in the perl program complaint about
can not find. Oracle lib
I will check it and send you the info when I get to the office
Thanks
I
_
Mike Tofigh
Digicon Contractor
301-213-6640
Sent from my
is an extract from a
level 3 trace ...
DBI::db=HASH(0x61b8350) trace level set to 0x0/3 (DBI @
0x0/47120086204416) in DBI 1.52-ithread (pid 27618)
- prepare for DBD::Oracle::db (DBI::db=HASH(0x61a64d0)~0x61b8350 '
INSERT
INTOsb_demo(data_b
Deo wrote:
On Sep 2, 7:59 pm, [EMAIL PROTECTED] (John Scoles) wrote:
Can you send us the output of the Perl Makefile.PL?
At first glance it look like you are trying to compile against an old
client?
Deo wrote:
Hello...
I am trying to build DBD-Oracle-1.16 onAIXbox
be broken. Here is an extract from a
level 3 trace ...
DBI::db=HASH(0x61b8350) trace level set to 0x0/3 (DBI @
0x0/47120086204416) in DBI 1.52-ithread (pid 27618)
- prepare for DBD::Oracle::db (DBI::db=HASH(0x61a64d0)~0x61b8350 '
INSERT
INTOsb_demo(data_b
601 - 700 of 3490 matches
Mail list logo