From: Sam Sang <younoeme@...>
Date: 2008-10-16T07:10:34+09:00
Subject: Re: Ruby with Oracle forward slash error




Robert Klemme wrote:
> 2008/10/7 Sam Sang <younoeme@hotmail.com>:
>>
>>
>> -- RUBY file
>>
>> class CrosstabReportsObjectType < ActiveRecord::Migration
>>  def self.up
>>        type = File.open(File.join(File.dirname(__FILE__), 'type',
>> 'testSQL.sql')).read
> 
> Maybe you can try this additional line:
> 
> type.gsub! %r{^/}, ''

Many thanks for the reply Robert.  I suppose this command tries to 
replace the slash in the sql file.  When executed, I now get an error

PLS-00103: Encountered the symbol "CREATE" : BEGIN.



> See above. But normally I'd parse the text in chunks using the slash
> at the beginning of the line as delimiter and submit statements
> separately.

Not sure what you mean.. could you please elaborate a bit?

Thanks again,
-- 
Posted via http://www.ruby-forum.com/.