Advice required.
I have report table which will store both text clob and binary blob data. There is column indicating whether data is blob or clob.
Which would you choose of below and why?
- One blob column where store blob directly and return blob to caller. For clobs convert to blob before store and convert blob back to clob to return to caller.
- One blob column for blob data and one clob column for clob data. No conversions required.
Was originally leaning to option 1, but rethinking as when store and return lob, need to know what kind of data are dealing with anyway, so modules required for each. The conversion process (dbms_lob.converttoblob/dbms_lob.converttoclob (aware APEX 23 has equivalent modules, but do not have yet)) works well, so that is not big issue.