> They have a problem whereby saving any LONG RAW data to the database
"LONG xy" datatypes are often a problem, better use BLOB datatype
instead of thos LONG RAW. "LONGs" are a legacy from oracle 7, which were
silly to use as needed to be chuncked into several parts, etc. baaahh
better use BLOBs, that's my advice. Look into DBMS_LOB docs for the API,
works fine for any images, sound, binary doc you may dream about.
2nd advice : setup BLOBs in a separate tablespace with a big block size,
and with a dedicated cache zone in SGA if you heavily use them, it's way
quicker.
rgds,
Patrice Castet
sr Oracle DBA
Received on Fri Sep 15 2006 - 05:19:21 CDT
