long raw, blob, clob or nclob in oracle?

rbuser

hi

which type i can/must use for storing the reports in oracle?
at the moment we are using long raw. when i change the type to blob we are
getting error messages while reading from this field (ALTER TABLE ALL_ITEM
MODIFY(TEMPLATE CLOB)).

thx
rico



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Rico,

Below is the SQL code we use to create the RB_ITEM table. The TEMPLATE
field is a BLOB type.


CREATE TABLE RB_ITEM (
ITEM_ID NUMBER(6, 0) DEFAULT 0 ,
FOLDER_ID NUMBER(6, 0) DEFAULT 0,
ITEM_NAME CHAR(60),
ITEM_SIZE NUMBER(6, 0) DEFAULT 0,
ITEM_TYPE NUMBER(6, 0) DEFAULT 0,
MODIFIED NUMBER,
DELETED NUMBER,
TEMPLATE BLOB);

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com