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,

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
Received on Thu Feb 17 2011 - 03:32:23 CST

Original text of this message