dbi, oracle parse issues again

D

Daniel Berger

Hi all,

Ruby 1.8.1
dbi 0.0.21
Oracle 9.2.x

This bit of sql is choking with dbi, again due to the comment line for
some reason:

--some_comment
select some_log_col, some_date_col
from x.some_log
where some_other_col = ?
and trunc(some_date) > '03-Apr-01'
order by some_date desc

It works if I remove the comment. No, changing the ? to :1 doesn't
matter. Yes, it works in sqlplus and TOAD, but not in TORA.

Any ideas?

Regards,

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,480
Members
44,900
Latest member
Nell636132

Latest Threads

Top