Using CLOB in structure table

Hello everybody,





I'd like to use CLOB in structure table instead of LONG RAW.


So the only things I have to do is to replace LONG RAW by CLOB in create table SQL script?


Will JChemSearch and other Object will identify automatically the SQL.Type of the column or is there parameters I need to change.





Thanks a lot for your answer.


Regards,


Jacques





I'm using Jchem 3.0.4 with Oracle 9.2

Hi Jacques,





You can use both BLOB and CLOB for the type of the cd_structure column.





Yes, you only have to replace "LONG RAW" to "BLOB" or "CLOB" in the table creation dialog.





JChem classes will automatically recognize the column type, you do not have to worry about that.





The only potential problem with the CLOB type is a significant slowdown of the import process.


We still have to investigate this issue.


Until then I recommend using the BLOB type, which has no impact on import performance.





Szilard

Thank you very much for your help, Szilard.


I will use BLOB instead of CLOB.


Kind regards.