Re: return CLOB via Perl/DBI

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 26 Jun 2003 19:14:10 +0100
Message-ID: <q2dmfvkl89o6o7esauvf456jn7r8flaqeg@4ax.com>

On 26 Jun 2003 09:25:05 -0700, datavector_at_hotmail.com (Ken Chesak) wrote:

>I changed the column to long varchar and everything worked fine.

LONG is a terrible datatype - definitely get DBD::Oracle relinked against the right libraries rather than resorting to LONGs.

>The Unix guys did the build I will check with them about the Oracle 7
>libraries version. Is there an easy way to tell?

It is linked against Oracle 7 because of the reference to 'odescr' rather than OCIDescribe in the error message, and the error message itself.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Received on Thu Jun 26 2003 - 13:14:10 CDT