ini ada contoh update ke field yg bertipe BLOB. kayanya sama aja.. contoh ini saya pake untuk masukan file atau image ke database.
declare vsp_ID number; vv BLOB; BEGIN if :P4_SMALL_PICTURE is not null then SELECT ID,BLOB_CONTENT INTO vsp_ID,vv FROM WWV_FLOW_FILES WHERE NAME = :P4_SMALL_PICTURE; UPDATE DP_CONTENT_HEADERS set DPCH_SMALL_PICTURE = vv, ATTRIBUTE5= vsp_ID, ATTRIBUTE6= :P4_SMALL_PICTURE WHERE DPCH_ID= :P4_DPCH_ID; end if; end; semoga membantu, Zul Ashfi. Oracle Application & Apps Express Developer IT Department Sec AppDev PT Daya Adira Mustika Jln Raya Cibereum 26, Bandung 0856 8430031, 022-91993173 --- On Sat, 5/9/09, Suripno Uribe Suripno <[email protected]> wrote: From: Suripno Uribe Suripno <[email protected]> Subject: [indo-oracle] blob To: [email protected] Date: Saturday, May 9, 2009, 10:43 AM dear semuanya, saya lagibelajar PLSQL Oracle 9i. gimana caranya memasukan/insert data yang bertipe blob. tanks. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
