Re: varchar2(8000)
From: jo <jose.soares_at_sferacarta.com>
Date: Thu, 17 Feb 2011 12:59:14 +0100
Message-ID: <4D5D0D92.8060408_at_sferacarta.com>
I solved by using str(),
thanks anyway
j
jo wrote:
> Hi all,
>
> I need to create a table like this one:
>
> create table session (
> id varchar2(40),
> data varchar2(8000),
> expiration_time timestamp
> )
>
>
> unfortunately varchar2 has a limit of 4000 char.
> I tried CLOB, NCLOB but I can't use them because I need to pass it to
> pickle and pickle wants a tring as argument
>
> |>> <http://newjosedev.sferacarta.com:8000/#>data *=*
> pickle*.*loads*(*pickled_data*)*|
> *TypeError: ('loads() argument 1 must be string, not cx_Oracle.LOB',
> <bound method Root.index of <sicer.BASE.controller.Root object at
> 0x8231f10>>)*
>
>
>
> What kind of type can I use to avoid this?
> thank you,
>
> j
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
Date: Thu, 17 Feb 2011 12:59:14 +0100
Message-ID: <4D5D0D92.8060408_at_sferacarta.com>
I solved by using str(),
thanks anyway
j
jo wrote:
> Hi all,
>
> I need to create a table like this one:
>
> create table session (
> id varchar2(40),
> data varchar2(8000),
> expiration_time timestamp
> )
>
>
> unfortunately varchar2 has a limit of 4000 char.
> I tried CLOB, NCLOB but I can't use them because I need to pass it to
> pickle and pickle wants a tring as argument
>
> |>> <http://newjosedev.sferacarta.com:8000/#>data *=*
> pickle*.*loads*(*pickled_data*)*|
> *TypeError: ('loads() argument 1 must be string, not cx_Oracle.LOB',
> <bound method Root.index of <sicer.BASE.controller.Root object at
> 0x8231f10>>)*
>
>
>
> What kind of type can I use to avoid this?
> thank you,
>
> j
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Jose Soares Sferacarta Net Via Bazzanese 69 40033 Casalecchio di Reno Bologna - Italy Ph +39051591054 fax +390516131537 web:www.sferacarta.com Le informazioni contenute nella presente mail ed in ogni eventuale file allegato sono riservate e, comunque, destinate esclusivamente alla persona o ente sopraindicati, ai sensi del decreto legislativo 30 giugno 2003, n. 196. La diffusione, distribuzione e/o copiatura della mail trasmessa, da parte di qualsiasi soggetto diverso dal destinatario, sono vietate. La correttezza, l’integrità e la sicurezza della presente mail non possono essere garantite. Se avete ricevuto questa mail per errore, Vi preghiamo di contattarci immediatamente e di eliminarla. Grazie. This communication is intended only for use by the addressee, pursuant to legislative decree 30 June 2003, n. 196. It may contain confidential or privileged information. You should not copy or use it to disclose its contents to any other person. Transmission cannot be guaranteed to be error-free, complete and secure. If you are not the intended recipient and receive this communication unintentionally, please inform us immediately and then delete this message from your system. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 17 2011 - 05:59:14 CST