Hi!
> > > There's a newer linux-oracle-instantclient-sdk available in the
> > > ports (10.2.0.3), and maybe it helps to compile and link a newer
> > > DBD::Oracle.
> >
> > I have that one (actually, those three), but they are nine
> > years old as well: 20061115_5 is coded into the ports name.
>
Hi!
> > There's a newer linux-oracle-instantclient-sdk available in the
> > ports (10.2.0.3), and maybe it helps to compile and link a newer
> > DBD::Oracle.
>
> I have that one (actually, those three), but they are nine
> years old as well: 20061115_5 is coded into the ports name.
The API did n
According to Kurt Jaeger on Thu, 06/04/15 at 09:38:
>
> My guess: no-one had the need, time and skills to fix it.
>
> There's a newer linux-oracle-instantclient-sdk available in the
> ports (10.2.0.3), and maybe it helps to compile and link a newer
> DBD::Oracle.
I have that one (actually, thos
Hi!
> According to Kurt Jaeger on Thu, 06/04/15 at 02:50:
> > DBD::Oracle no longer supports Oracle client versions before 9.2
> > Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
> >
> > and there is no oracle9-client port on FreeBSD.
>
> Thanks. That makes sense.
According to Kurt Jaeger on Thu, 06/04/15 at 02:50:
>
> DBD::Oracle no longer supports Oracle client versions before 9.2
> Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
>
> and there is no oracle9-client port on FreeBSD.
Thanks. That makes sense. What doesn't ma
Hi!
> What is confusing to me is why FreeBSD _still_ contains
> DBD::Oracle 1.19 in their "ports" tree! After all these years!
Because:
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
and there is no
in message <20150603172207.gf2...@itcom245.staff.itd.umich.edu>,
wrote William Bulley thusly...
>
...
> My focus now is trying to install DBD::Oracle 1.74 from CPAN (from
> April of 2014) on my system.
...
> What is confusing to me is why FreeBSD _still_ contains
> DBD::Oracle 1.19 in their "ports"
According to "Howard, Chris" on Wed, 06/03/15 at 13:09:
>
> I was hoping you could share the actual code
> with us. But no problem. Sounds like you have
> some good clues.
>
> Using Oracle 8 client and ancient DBI libraries
> probably isn't helping, but also seems unlikely to hurt.
>
> I'm le
cat scriptname | od -bc | more
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Wednesday, June 03, 2015 11:13 AM
To: William Bulley
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
> On Jun 3, 2015, at 9:44 AM, Will
> On Jun 3, 2015, at 9:44 AM, William Bulley wrote:
>
> Martin thinks the parsing in the dbd_preparse() function within the
> dbdimp.c file (part of DBD::Oracle) has issues so that it cannot deal
> with the second question mark given the preceding single quote(s).
>
> It seems plausible, yet od
To: Howard, Chris
Cc: Martin J. Evans; dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Howard, Chris" on Wed, 06/03/15 at 12:30:
>
> Thanks!
> And what does $query contain?
That is the issue! Martin has worked with me off-line and clearly
th
According to "Howard, Chris" on Wed, 06/03/15 at 12:30:
>
> Thanks!
> And what does $query contain?
That is the issue! Martin has worked with me off-line and clearly
the query contained some quote characters. I've attempted to either
remove those or quote them the DBI quote() way, but since so
Thanks!
And what does $query contain?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 9:14 AM
To: Howard, Chris
Cc: Martin J. Evans; dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Howard,
On 03/06/15 14:06, William Bulley wrote:
Environment Perl script trying to query Oracle 11g database:
FreeBSD 9.3-STABLE
DBI 1.633
oracle8-client 0.2.0
DBD::Oracle 1.19
It seems I missed this ^
A 9 year old DBD::Oracle. I can well believe the preparse code has changed o
On 03/06/15 17:12, Bruce Johnson wrote:
On Jun 3, 2015, at 7:19 AM, William Bulley wrote:
According to Bruce Johnson on Wed, 06/03/15 at
10:10:
Make sure your original $query is delimited by double quotes, not single.
I've tried _everything_!!
Single quotes. Double quotes. q{} and
> On Jun 3, 2015, at 7:19 AM, William Bulley wrote:
>
> According to Bruce Johnson on Wed, 06/03/15
> at 10:10:
>>
>>
>> Make sure your original $query is delimited by double quotes, not single.
>
> I've tried _everything_!!
>
> Single quotes. Double quotes. q{} and qq{} (using the lat
According to "Howard, Chris" on Wed, 06/03/15 at 10:44:
>
> Can you post a copy of your prepare statement?
Sure. Here it is:
$sth = $dbh->prepare ($query) or die "Couldn't prepare statement: " .
$dbh->errstr;
Regards,
web...
--
/"\ ASCII RIBBON / William Bulley
\ / CAMP
Can you post a copy of your prepare statement?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 7:57 AM
To: Martin J. Evans
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Martin J. Evans&quo
According to Bruce Johnson on Wed, 06/03/15 at
10:10:
>
>
> Make sure your original $query is delimited by double quotes, not single.
I've tried _everything_!!
Single quotes. Double quotes. q{} and qq{} (using the latter now).
But no matter what I try DBI complains about the darn questio
> On Jun 3, 2015, at 6:57 AM, William Bulley wrote:
>
> Yep, I've been all over the net looking for this issue. I am not
> doing anything wrong -- the "invalid string" is the darn "?"!!!
Make sure your original $query is delimited by double quotes, not single.
if you do $sth->prepare(‘selec
According to "Martin J. Evans" on Wed, 06/03/15 at 09:48:
>
> Sounds ok but the error is "invalid string"
>
> ORA-0911
> You tried to execute a SQL statement that included a special character.
>
> http://www.techonthenet.com/oracle/errors/ora00911.php
> lists various causes.
Yep, I've been all
On 03/06/15 14:38, William Bulley wrote:
According to "Martin J. Evans" on Wed, 06/03/15 at 09:15:
So, when this fails, what is the value of $value.
I just ran it again. The value is 547.
Sounds ok but the error is "invalid string"
ORA-0911
You tried to execute a SQL statement that inclu
According to "Martin J. Evans" on Wed, 06/03/15 at 09:15:
>
> So, when this fails, what is the value of $value.
I just ran it again. The value is 547.
> Assuming you have RaiseError set, you can just put an eval
> around the execute and if $@ is set, print out $value.
I don't. I have a print
On 03/06/15 14:06, William Bulley wrote:
Environment Perl script trying to query Oracle 11g database:
FreeBSD 9.3-STABLE
DBI 1.633
oracle8-client 0.2.0
DBD::Oracle 1.19
I have no trouble connecting with the Oracle database. And I do
recover data when I use the temporary work
Environment Perl script trying to query Oracle 11g database:
FreeBSD 9.3-STABLE
DBI 1.633
oracle8-client 0.2.0
DBD::Oracle 1.19
I have no trouble connecting with the Oracle database. And I do
recover data when I use the temporary workaround described below.
I have a query/prepare
25 matches
Mail list logo
