clob fields

[lynn_sai]

Hi,
My Paradox tables have several formatted memo fields which I want to save into MS Word and to store in CLOB or BLOB field in Oracle database.
Please tell me the whole procedure doing it. It'd be appreciated........

Thanks in advance

 

[Marco Kalter]

I'm not sure how to convert your memo fields to MS Word files, but you can use the TLOBLocator.LoadFromFile procedure to load the file into a BLOB column. See the TLOBLocator documentation for more details and some examples on how to update or insert LOB data.

------------------
Marco Kalter
Allround Automations

 

[lynn_sai]

Hi Marco,

I think I wasn't clearly explaining my question. What I meant was how to store CLOB field's files (files : the content of CLOB fields were save in word documents) in the same tablespace as the rest of schema data...

Thanks in advance