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 tree!
According to Martin J. Evans boh...@ntlworld.com 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
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
On Jun 3, 2015, at 6:57 AM, William Bulley w...@umich.edu 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
According to Bruce Johnson john...@pharmacy.arizona.edu 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
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
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
According to Martin J. Evans boh...@ntlworld.com 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.
On 03/06/15 14:38, William Bulley wrote:
According to Martin J. Evans boh...@ntlworld.com 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
According to Howard, Chris howa...@prpa.org 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
\
On Jun 3, 2015, at 7:19 AM, William Bulley w...@umich.edu wrote:
According to Bruce Johnson john...@pharmacy.arizona.edu 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.
On 03/06/15 17:12, Bruce Johnson wrote:
On Jun 3, 2015, at 7:19 AM, William Bulley w...@umich.edu wrote:
According to Bruce Johnson john...@pharmacy.arizona.edu on Wed, 06/03/15 at
10:10:
Make sure your original $query is delimited by double quotes, not single.
I've tried
On Jun 3, 2015, at 9:44 AM, William Bulley w...@umich.edu 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
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, William
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
15 matches
Mail list logo