how to get the contents of the clob file
Printable View
how to get the contents of the clob file
In order to access data fromthe clob column we need to make use of various functions. If u want some examples regarding the same do mention and i can send u the tested example for the same.
You may want to use DBMS_LOB package:
DBMS_LOB.READ (lob_loc, amount, offset, buffer);
Parameter Description:
lob_loc - Locator for the LOB to be read.
amount - Number of characters (for CLOBs) to read
offset - Offset in characters (for CLOBs) from the start of
the LOB
buffer - Output buffer for the read operation.
Dear Miritika,
We have altered our table and included a field of the type CLOB.
Therefore, I need to record and consult information in this field.
Due to the lack of information about this kind of field I solicit that you
send me off the routines so that I can execute inclusion, consultation, and
alteration in these fields.
Sincerely,
Francisco Carlos Saores de Assis