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
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