datatype

[shashikumar]

how to get the contents of the clob file

[miritika]

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.

[kris109]

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.

[Francisco]

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