According to "Martin J. Evans" <[email protected]> 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 over the net looking for this issue. I am not
doing anything wrong -- the "invalid string" is the darn "?"!!!
DBD::Oracle::db prepare failed: ORA-00911: invalid character
(DBD ERROR: error possibly near <*> indicator at char 370 in '
select distinct s.ITEMIDNUM,
c.STATUSDES,
s.ADDRESS128BIT,
s.PREFIX_LEN,
s.ENDADDRESS128BIT,
s.CREATED_USER,
to_char(s.CREATED_DATE, 'YYYY-MM-DD HH24:MI:SS'),
i.ITEMDES,
i.COMMENTS,
s.RESERVEDFOR,
s.AGGREGATE_STATUS,
i.STATUSCD,
i.ITEMNAME
from UMNET_ONLINE.IP6NET s, UMNET_ONLINE.ITEM i,
UMNET_ONLINE.STATUS_CODE c
where i.PARENTITEMIDNUM = <*>?
and i.ITEMIDNUM = s.ITEMIDNUM
and i.STATUSCD = c.STATUSCD
and i.ITEMCATCD like 'IPv6'
union
select distinct s.ITEMIDNUM,
c.ITEMRELTYPDES,
s.ADDRESS128BIT,
s.PREFIX_LEN,
s.ENDADDRESS128BIT,
s.CREATED_USER,
...'
You can see the error complaining about the question mark above.
There is a second question mark in the second select statement.
> I'm not sure I'd trust that - doesn't that mean you are
> expecting stdin and stout to be in order.
Yes, and they are.
> If you can easily do it I would stick an eval around it and
> trap it that way. Also, if you trap it you can print the SQL using
> http://search.cpan.org/~timb/DBI-1.633/DBI.pm#Statement
> and the parameters using
> http://search.cpan.org/~timb/DBI-1.633/DBI.pm#ParamValues
I'll have to look into that. But recall this: I am not getting
to the execute() statement. The above error is on the prepare()
statment. This is so very confusing to me...
> I would not bother changing from ? to named - I seriously doubt this is the
> issue.
And you can see from the above that the question mark is back
in the mix.
> http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm#ora_verbose
>
> Can be set in the connect attributes.
Thanks. :-)
> If I were you I'd try and simply the original case down as much as
> possible but getting a trace with ora_verbose might help identify the problem.
Okay, I'll try that next.
Regards,
web...
--
/"\ ASCII RIBBON / William Bulley
\ / CAMPAIGN AGAINST /
X HTML E-MAIL AND / E-MAIL: [email protected]
/ \ LISTSERV POSTINGS /
72 characters width template ----------------------------------------->|
