According to "Howard, Chris" <howa...@prpa.org> 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 some of
my columns have VARCHAR2 types, I must issue this sort of syntax in
my WHERE clause:
column LIKE 'something'
It can't be avoided. And since the basic structure of the "query"
is like this:
select distinct
column,
column,
column
from table, table, table
where column = ?
column = column,
column = column,
column LIKE 'something'
union
select distinct
column,
column,
column
from table, table, table
where column = ?
column = column,
column = column,
column LIKE 'something'
Note the two question marks. The first one passes muster, but the
second one is flagged as an error (invalid character):
DBD::Oracle::db prepare failed: ORA-00911: invalid character
(DBD ERROR: error possibly near <*> indicator at char 788 in'
<< snipped query here>>' at script.pl line xxx
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 odd, to me, but it isn't my module. Perhaps
I have an older version? I dunno... :-(
Regards,
web...
--
/"\ ASCII RIBBON / William Bulley
\ / CAMPAIGN AGAINST /
X HTML E-MAIL AND / E-MAIL: w...@umich.edu
/ \ LISTSERV POSTINGS /
72 characters width template ----------------------------------------->|
