[Tutor] python cx_Oracle.LOB
jalilsan at gmail.com
Tue Jan 2 22:09:53 CET 2007
here is my code
db = cx_Oracle.connect('xxxxxx','xxxxx','xxxx')
#cursor.execute('set long 5000')
#sqlen="""set long 5000"""
sqtext="""select TExt from sq_updates where action_id= '851151'"""
rettext = cursor.fetchmany()
On 1/2/07, Jason Massey <jason.massey at gmail.com> wrote:
> An example of your code would help. According to the cx_oracle docs at
> http://www.python.net/crew/atuining/cx_Oracle/html/index.html under the
> LOB Objects heading:
> 6. LOB Objects
> *NOTE*: This object is an extension the DB API. It is returned whenever
> Oracle CLOB, BLOB and BFILE columns are fetched.
> *NOTE*: Internally, Oracle uses LOB locators which are allocated based on
> the cursor array size. Thus, it is important that the data in the LOB object
> be manipulated before another internal fetch takes place. The safest way to
> do this is to use the cursor as an iterator. In particular, do not use the
> fetchall() method. The exception "LOB variable no longer valid after
> subsequent fetch" will be raised if an attempt to access a LOB variable
> after a subsequent fetch is detected.
> *fileexists*( ) Return a boolean indicating if the file referenced by the
> BFILE type LOB exists.
> *getfilename*( ) Return a two-tuple consisting of the directory alias and
> file name for a BFILE type LOB.
> *read*( [offset = 1, [amount]]) Return a portion (or all) of the data in
> the LOB object.
> *setfilename*( dirAlias, name) Set the directory alias and name of the
> BFILE type LOB.
> *size*( ) Returns the size of the data in the LOB object.
> *trim*( [newSize = 0]) Trim the LOB to the new size.
> *write*( data, [offset = 1]) Write the data to the LOB object at the
> given offset. Note that if you want to make the LOB value smaller, you must
> use the trim() function.
> I'd try the read method on your object.
> On 1/2/07, Jalil <jalilsan at gmail.com> wrote:
> > I am trying to fetch a CLOB datatype with with cx_Oracle and I can seem
> > to get it to work.
> > I was able to fetch the text from the db with sql commands but i can
> > fetch in a python code.
> > I get this output.
> > [(<cx_Oracle.LOB object at 0xb7f23530>,)]
> > when I run my code.
> > any way to find out how to go around this?
> > _______________________________________________
> > Tutor maillist - Tutor at python.org
> > http://mail.python.org/mailman/listinfo/tutor
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Tutor