varchar2(8000)

From: jo <jose.soares@xxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 17 Feb 2011 10:32:23 +0100

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 topickle 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 at0x8231f10>>)*




What kind of type can I use to avoid this?
thank you,

j

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: varchar2(8000)
From: jo

varchar2(8000)

Other related posts: