From: "Berger, Daniel" <djberge@...>
Date: 2003-01-31T00:27:12+09:00
Subject: Re: ruby-dbi and oracle error - ORA-24374



> -----Original Message-----
> From: Gavin Sinclair [mailto:gsinclair@soyabean.com.au] 
> 
> Interesting.  What's TORA?

Oh, sorry.  "Tool for Oracle".  An opensource, *nix clone of TOAD.  It's not
quite as good as TOAD, but then it works on *nix and there's just one guy
developing it.

TORA - http://tora.sourceforge.net
TOAD - http://www.quest.com/toad/
 
> > Interestingly, changing the "?" to a fixed value fixes the parsing 
> > error in ruby-dbi, although TORA still chokes.
> 
> > Is this an oracle driver problem or a ruby-dbi problem?  
> And can it be 
> > fixed (please)?
> 
> A workaround would be to add a tautological line to your 
> query.  Like "and 1 < 2".
> 
> Gavin

That'll work.  That reminds me, this only happens if the placeholder is the
*last* thing in the sql statement.

Thanks Gavin.

Regards,

Dan