From: djberg96@... (Daniel Berger)
Date: 2004-04-02T05:34:22+09:00
Subject: dbi, oracle parse issues again

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