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 some
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
>
>
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, ho
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 Beer)
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.
Version
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)
>
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
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
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
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 : 1
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 qw()
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 lev
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 Scol
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 warnings;
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
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,
Stev
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 perfectl
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,
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';
m
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 L
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 * fro
Hi,
We are *sporadically* getting the following error when accessing a table
with a single CLOB column (on DBI 1.607 and DBD::Oracle 1.22):
DBD ERROR: Can't match some parameters to LOB fields in the table, check
type and name
This is what we use to bind the data to the CLOB for our UPDATE state
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 DBD::Oracle
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 set
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 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)
WORKS!
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 conne
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
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 UTF-
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
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,
Hi there,
Has anyone seen this message before?
install_driver(Oracle) failed: DBD::Oracle object version 1.16 does not
match bootstrap parameter 1.06 at C:/Perl/lib/DynaLoader.pm line 253.
If so do you know how to fix it? I am running windows 2000 with an
Oracle 9i client and ActivePerl 5.8.
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 clien
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
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
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 rdbms/demo
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
On Wed, Nov 24, 2004 at 08:07:33AM -0500, Hardy Merrill wrote:
> Tim, can you elaborate a little? I've tried to find the referenced
> documentation but can't. I don't quite understand how a CHAR datatype
> can cause this problem.
Well there's:
> See
> http://search.cpan.org/~timb/DBD-Oracle-1.1
On 11/24/2004 05:07 AM, Hardy Merrill said:
Tim, can you elaborate a little? I've tried to find the referenced
documentation but can't. I don't quite understand how a CHAR datatype
can cause this problem.
CHAR column values are padded with spaces to the length of the column.
When compared with a
Tim, can you elaborate a little? I've tried to find the referenced
documentation but can't. I don't quite understand how a CHAR datatype
can cause this problem.
Thanks.
Hardy Merrill
>>> Tim Bunce <[EMAIL PROTECTED]> 11/24/04 07:35AM >>>
On Tue, Nov 23, 2004 at 10:13:30PM +, Bart Kelsey w
On Tue, Nov 23, 2004 at 10:13:30PM +, Bart Kelsey wrote:
> I'm having some trouble with DBD::Oracle...
> When I execute this code:
> ***
>
>$sth = $dbh->prepare("select * from abbrev where type = ?");
>$sth->execute("PAYMENT");
>while((@row) = $sth->fetchrow_array) {
> print(j
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
-
Hello Bart,
I run DBD::Oracle version 1.16 with DBI 1.41-ithread
on Windows XP accessing Oracle8i Release 8.1.7.4.1
I can't reproduce your problem.
Do you check for errors? Do you use RaiseError?
Did you try to produce a trace? Add something like this:
DBI->trace(9,"dbitrace.txt");
Tuesday, N
I'm having some trouble with DBD::Oracle...
When I execute this code:
***
$sth = $dbh->prepare("select * from abbrev where type = ?");
$sth->execute("PAYMENT");
while((@row) = $sth->fetchrow_array) {
print(join(", ", @row), "\n");
}
$sth->finish;
***
... no rows are returned. H
>
> 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 e
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
ay 03, 2004 4:39 PM
To: [EMAIL PROTECTED]
Subject: DBD::Oracle problem
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
Thanks for the help from everyone. It was a permissions problem.
"Ronald J Kimball" <[EMAIL PROTECTED]> on 05/04/2004 09:24:53 AM
To:"'Richard J McWaters'" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
cc:
Subject:RE: :O
Richard J McWaters [mailto:[EMAIL PROTECTED] wrote:
> I am able to run make install and also to run perl programs that access
> other oracle databases from the command line on this machine. This
> machine
> is a web server, and my problem is when I try to access the database from
> a
> Perl progr
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 e
[EMAIL PROTECTED]
Subject: DBD::Oracle problem
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 d
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 er
Using the following version of Perl:
This is perl, v5.8.2 built for MSWin32-x86-multi-thread
(with 25 registered patches, see perl -V for more detail)
...
Binary build 808 provided by ActiveState Corp. http://www.ActiveState.com
ActiveState is a division of Sophos.
Built Dec 9 2003 10:19:40
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
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 9.2.
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 dbms
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
' instead
CGI script.
print "Content-Type: text/html\n\n";
foreach $key (sort keys %ENV) {
print "$key=$ENV{$key}\n"
}
glen accardo
BMC Software, Inc.
-Original Message-
From: rao [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 11:43 PM
To: [EMAIL PROTECTED]
Hello everybody
I was using perl-cgi on apache and was able to run all my application on oracle 8i
database. Now at this moment being asked to implment the entire application on to
iPlanet instead of Apache.
I am able to configure the iPlanet server for cgi and the pages with the DB
connectio
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: /us
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: /usr/local/bin/perl: fatal:libclntsh.so.1.0: open failed:
No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLo
> I think you're confusing END with DESTROY. `perldoc perlmod`.
Damn - you're right. What am I thinking?
Anyway, when I just run it at the command line it just...dies. No warnings,
errors, no nothing. It was very weird.
A few hours later, it started working again, without any logic chang
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Feb 08, 2002 at 02:20:21PM -0600, Berger, Daniel wrote:
> I understand that. What I don't understand is why it's dumping there in the
> first place if I've already successfully closed (i.e. disconnected) the (one
> and only) database handle.
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Fri, Feb 08, 2002 at 01:00:37PM -0600, Berger, Daniel wrote:
> > However, as soon as I try to step into the "someOtherSub()"
> sub, the program
> >
> > dumps me into the Oracle.pm module. I never even get to
> the first line of
> > "s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Feb 08, 2002 at 01:00:37PM -0600, Berger, Daniel wrote:
> However, as soon as I try to step into the "someOtherSub()" sub, the program
>
> dumps me into the Oracle.pm module. I never even get to the first line of
> "someOtherSub()". It die
Perl 5.6.1, DBI 1.20, DBD-Oracle 1.12
I have this simple program that was working fine yesterday. This morning
I'm
getting odd problems. The only database connection I make is the very
simple
query I make in the 'getHosts()' sub. The query seems to run fine - I get
results and I can step to
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 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
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
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 any idea on how to solve
son
Pfizer, 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 $ORA
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
x27;[EMAIL 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,
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 (r
Javier -
I have not had any luck on Solaris or Win2000 with DBI 1.15 and
DBD::Oracle. DBD::Oracle fails some of the same tests for me as you
described in your e-mail, even though DBI installs and tests fine. The only
solution for me was backing up to DBI 1.14. I don't have the patience to
rebu
Hi All,
I have a very similar problem to Bob Reuss where my script works ok on the
DOS command line but fails in the browser. My working environment is just
like his (using Perl/CGI on a windows2000 machine running IIS to connect to
an Oracle DB on a Sun WkStation) except that I use the Oracle Dr
Hello all,
I have been attempting to use DBI::ODBC on a windows 2000 machine running
IIS to connect to an Oracle database on a Unix machine. I have set up the
DSN for the ODBC connection and I can actually get a connection to the
database and retrieve data when I call cgi page from a command lin
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
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
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 under
the new DBI.
My configuration may be a little odd, so it would be use
Julio Santiago
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.
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: /usr
n if I 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, 1
-
From: "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 me
Or am I thinking too much in C terms there?
>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 04:47:59 -0800
>
>T
ring 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 th
Irina" <[EMAIL PROTECTED]>
>To: "'P B'" <[EMAIL PROTECTED]>
>CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: DBI with DBD::Oracle Problem #2
>Date: Thu, 25 Jan 2001 13:15:17 -0500
>
>The error, you get, happens
Hi all,
Many thanks for the suggestions, the 'chomp' command did the trick.
Cheers
David.
7;; [EMAIL PROTECTED]
Subject: RE: :Oracle problem
Does the password file contain only one password? If so, does it contain a
newline character at the end of it?
-Original Message-
From: David Sherrington - Enterprise Services- Data Management Systems
Engineer [mailto:[EMAIL PROTEC
: [EMAIL PROTECTED]
Subject: DBI::Oracle problem
Hello,
I've have a problem with connecting to an Oracle database using DBI under Unix.
Basically, I have the Database user passwords in a unix flat file, which I read
into the perl script setting a local variable. The Oracle database name an
PROTECTED]>
Subject: DBI::Oracle problem
To: [EMAIL PROTECTED]
David,
>
> I've have a problem with connecting to an Oracle database using DBI under Unix.
>
> Basically, I have the Database user passwords in a unix flat file, which I read
>
Hello,
I've have a problem with connecting to an Oracle database using DBI under Unix.
Basically, I have the Database user passwords in a unix flat file, which I read
into the perl script setting a local variable. The Oracle database name and the
User name a passed to the perl script as arguem
Thanks for the info. I'll fix it for the next release (don't ask).
Tim.
On Sun, Jan 28, 2001 at 07:19:01PM +0200, Margarita Zlotnikov wrote:
> Hi Tim,
>
> We were trying to use DBD::Oracle (v. 1.06) for reading CLOBs, and we
> were getting an error message of the type:
>
> DBD::Oracle::st fet
me if I'm wrong).
Why you don't receive your data - that's another question. Are you sure that
your query returns a row?
Irina.
-Original Message-
From: P B [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:04 AM
To: [EMAIL PROTECTED]
Subject: DBI with DBD::Oracle P
97 matches
Mail list logo
