On Wed, 12 Mar 2008 10:22:11 -0400, <[EMAIL PROTECTED]> wrote:
Hi Mark been playing with the code you sent me for the past day or two
and
unfortunetly I have have made little progress with it.
Seems I get the value out of the Database no problem of the type
OCI_TYPECODE_CLOB, But I cannot tell if it is a lob_locator or not and
there seems no way to bind a decriptor to it.
It is a pointer to a lob locator. You need to do something like this:
OCILobLocator *lobloc = *(OCILobLocator**)valuep;
and then use OCILobGetLength and OCILobRead on the locator to get the data
out.
-P
So I am not sure I will be able to build in support for embedded clobs in
the next version of DBD::Oracle
I will work on it a little more today as there is still one thing I have
not tried but I do not see much of a future in it.
cheers
John Scoles
dear sir
i attach a tarball containing a sqlplus script, mt.sql which creates a
table and type, both of which contain an embedded clob field.
the file mt.lst is the sqlplus spooled output of mt.sql, and you can see
that the data is in the clob, and is accessible in the type.
the other two files are mt.pl and output mt.txt.
the clob field doesn't appear in the embedded version of the query.
i think this is a problem with DBD::Oracle.
following your instructions, i am sending this to yourselves first.
if i need to work on a fix, can u pls advise whereabouts i should look.
thanks for your time and for any feedback you can provide.
mr
