A client will use an http to pos several xml files. it will be posted to oracle database stored procedure via mod_plsql.
by default the pl/sql gateway saves those files as a BLOB in DOCUMENTS_TABLE and saves a pointer (file name/number) to the other table TESTS_TABLE where i save the data.
1. Shall I keep the xml file as a BLOB data type in Documents table and access it from there?
Would i be limited in any way displaying the file or searching it etc..
2. Would it be useful to copy this BLOB file convert it into CLOB and stick it into TESTS_TABLE.
3. How do you do #2.