varchar2(8000)
From: jo <jose.soares_at_sferacarta.com>
Date: Thu, 17 Feb 2011 10:32:23 +0100
Message-ID: <4D5CEB27.2030005_at_sferacarta.com>
Hi all,
Date: Thu, 17 Feb 2011 10:32:23 +0100
Message-ID: <4D5CEB27.2030005_at_sferacarta.com>
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-lReceived on Thu Feb 17 2011 - 03:32:23 CST