HOW TO USE CLOB?

[shailendra]

HI

I AM GETTING ONE PROBLEM WHILE INSERTING DATA IN CLOB DATATYPE. ACTUALLY I WANT TO STORE A FILE SO CAN ANYBODY TELL ME WHAT WILL BE THE BEST OPTION IS THERE ANY OPTION TO STORE A FILE IN THE DATABASE OR THERE MAY BE SOME PROGRAM WHICH SPLIT THAT FILE AND INSERT INTO THE DATABASE PLESAE TELL ME AS SOON AS POSSIBLE ALSO IF IT IS POSSIBLE TO STORE A FILE IN THE DATABASE PLZ. TELL ME HOW TO DO IT? AS WELL AS I WANT TO SEARCH IN THAT FILE LATER ON PLEASE TELL ME WHAT TO DO?


THANKS IN ADVANCE
SHAILENDRA

[vbaskar]

the below example takes long as in parameter and sends out CLOB !! it is advisable to convert all the long cols to CLOB coz atleast using some packages (DBMS_LOB.INSTR ) u can search on the field..


Rgds


PROCEDURE ADD_LONG2LOB (pio_res IN OUT CLOB, pi_add IN long)
IS
v_lob_add CLOB;
v_size integer;
BEGIN
IF pi_add IS NOT NULL THEN
-- SELECT EMPTY_CLOB() INTO V_LOB_ADD FROM DUAL;
dbms_lob.CREATETEMPORARY(PIO_RES,true,dbms_lob.call);
select vsize(pi_add) into v_size from dual;
DBMS_OUTPUT.PUT_LINE(V_SIZE);
dbms_lob.WRITE(PIO_RES,v_size,1,pi_add);
-- dbms_lob.APPEND(pio_res,v_lob_add);
END IF;
--EXCEPTION
--WHEN OTHERS THEN
-- Raise_Application_Error('-20001','Error PROCEDURE ADD_LONG2LOB');
END ADD_LONG2LOB;