[DB-SIG] oracledb and LONG

Greg Stein gstein@lyra.org
Wed, 16 Sep 1998 14:51:57 -0700

Lixin Zhou wrote:
> I apologize if I am posting to a wrong group.
> How can I pull out the value of a LONG field using oracledb?  What
> returns by cursor.fetchone or cursor.fetchall is always an empty
> string (not None).

You should be getting back an object of type dbi.dbiRaw. The value of
the long is in its "value" attribute. For example:

row = cursor.fetchone()
longval = row[0].value

Hope that helps,

Greg Stein (gstein@lyra.org)