Hi,
I wrote a script which does compare the table content of a certain
table on different ORACLE-9i databases.
For this purpose I fetch all fields from the table in database one
and include the fetched values in the WHERE clause for execute the
statement at database two.
For numeric/char/varchar2 fields there are no problems.
However there are some tables with CLOB fields.
The first problem is that following binding in the WHERE clause does
not work:
WHERE my_clob_field = :value_from_database_1
Surprisingly the LIKE clause works for CLOB contents < 4kByte.
A transitional solution up to around 4kByte is to write
WHERE my_clob_field LIKE ':value_from_database_1'.
My questions:
- How can I get over this limit ?
I also had noticed that I had to specify a certain value for
$dbh->{LongReadLen}.
If the content of the database CLOB field is larger than the
specified value the fetch process fails.
Because CLOB fields can grow up to 4 GByte and I don't know
the largest content how can I avoid such a hard coded limit
for $dbh->{LongReadLen} ?
I hope the questions are not too much Oracle specific and belong
to DBI/DBD::Oracle.
Thomas
--
Bitte senden Sie mir keine Word- oder PowerPoint-Anh�nge.
See http://www.fsf.org/philosophy/no-word-attachments.de.html
-------------------------------------------------------------
NO ePATENTS: http://swpat.ffii.org/index.de.html
