From: Daniel Berger <djberge@...>
Date: 2003-02-15T04:45:54+09:00
Subject: Re: DBI, oracle, and prepare

Martin Bonner wrote:

<snip>

>#!c:\ruby\bin\ruby.exe -w
>require 'DBI'

Hmm...does Windows ignore case for module names?  Guess so.

>Error Message: ORA-01003: no statement parsed

This almost always means there was a problem parsing the SQL itself,
although looking at your code nothing obvious stands out.

Try wrapping the prepare and execute separately with begin/rescue to see
where the problem is (likely the prepare).  Be sure to test the same sql
on the command line (or TOAD or whatever) to make sure the sql is truly
valid.

HTH

Regards,

Dan

--
a = [74, 117, 115, 116, 32, 65, 110, 111, 116, 104, 101, 114, 32, 82]
a.push(117,98, 121, 32, 72, 97, 99, 107, 101, 114)
puts a.pack("C*")