From: Daniel Berger <djberge@...>
Date: 2003-01-31T02:21:14+09:00
Subject: ruby-dbi and oracle error - ORA-24374 - upon further review



> On Friday, January 31, 2003, 2:16:24 AM, Daniel wrote:
>
> > I've noticed a parsing problem with leading sql comments and sql that
> ends
> > with a placeholder.  For example,
>
> > --random comment
> > select column1, column2
> > from table1
> > where somevalue > ?
>

I should have posted a more accurate comment.  Try this:

--Dan's query
--random comment
select column1, column2
from table1
where somevalue = ?

The problem, it turns out, is the use of the apostrophe in the comment.
Strangely, this only causes a problem if used in conjunction with a
placeholder.  My testing shows that if I replace '?' with a fixed value it
works ok, even with the apostrophe.  This tells me that there's some sort
of parsing issue in sql.rb.  At least, that's my suspicion.  I'll see if
I can find the exact culprit.

Anyway, now you know.

Regards,

Dan