Re: varchar2(8000)
- From: jo <jose.soares@xxxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2011 12:59:14 +0100
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
