[Rails] Re: ORA-01704 string literal too long

>> Have you actually tired to store the 13 K byte string in a CLOB field? I did a simple copy/paste of the 13K data into the CLOB field and it worked fine. I checked the "show" view and the data is there. John -- Posted via http://www.ruby-forum.com/. -- You received this message because yo

[Rails] Re: ORA-01704 string literal too long

Thanks for the reply. > I would hope that the Ruby Oracle database > adaptor would take care dealing with the CLOB field. I had the standard Oracle Adapter but decided to install the Oracle Enhanced Adapter. > Have you actually tired to store the 13 K byte string in a CLOB field? No, next th

[Rails] Re: ORA-01704 string literal too long

John Mcleod wrote: > I've done some research and I know that Oracle's datatype 'Clob' will > hold the size but only at 4,000 chars. at a time. > I'm just wondering how to do it? According to what I can find on Oracle's CLOB data type is that they can store up to 4 gigabytes. I would hope that the

[Rails] Re: ORA-01704 string literal too long

Thank you for replying. I don't quite understand what you're doing. What do you mean by... >I'm guessing you'll need to change the value into it's ready-to-store binary >>format." John -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the