Hi John - this is good news!  I have tested out the new sequel gem you 
alerted us to: the 'create_table' method in storage.rb now works correctly 
(ie, the 'String :doc, :text => true, :null => false' line now correctly 
produces a CLOB column.
I am running into a more basic issue unfortunately: while the ruote engine 
works well most of the time, if the doc payload exceeds 4000 characters, I 
am getting another error:

** worker#step intercepted exception **

Please report issue or fix your Ruote::Sequel::Storage impl,

or override Ruote::Worker#handle_step_error(e, msg) so that
the issue is dealt with appropriately. For example:

    class Ruote::Worker
      def handle_step_error(e, msg)
        logger.error('ruote step error: ' + e.inspect)
        mailer.send_error('[email protected]', e)
      end
    end

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 
# # 

error class/message/backtrace:
Sequel::DatabaseError
"OCIError: ORA-01704: string literal too long"
stmt.c:235:in oci8lib_191.so

This seems to be related to the way Sequel is creating the INSERT.  I am 
able to trigger the same error using the Oracle SQL Developer tool, feeding 
in the SQL produced by the Sequel gem.

Geoff

On Wednesday, September 26, 2012 5:59:16 PM UTC-4, John Mettraux wrote:
>
> Hello, 
>
> speaking of Sequel and Oracle: 
>
>   https://groups.google.com/d/topic/sequel-talk/cArZglYRQK4/discussion 
>
> Best regards, 
>
> -- 
> John Mettraux   -   http://lambda.io/jmettraux 
>

-- 
you received this message because you are subscribed to the "ruote users" group.
to post : send email to [email protected]
to unsubscribe : send email to [email protected]
more options : http://groups.google.com/group/openwferu-users?hl=en

Reply via email to