ممكن ياجماعة حد يقولى ازاى بتتحمل الصور داخل اى جدول فى ال database

تحميل الصور فى database
تمت كتابته بواسطة
elkady_m2004
, September 12 2005 06:07 AM
3 رد (ردود) على هذا الموضوع
#2
تاريخ المشاركة 18 September 2005 - 11:10 AM
DECLARE
obj ORDSYS.ORDImage;
ctx RAW(64) :=NULL;
BEGIN
SELECT p.product_photo INTO obj FROM pm.online_media p
WHERE p.product_id = 3501 FOR UPDATE;
-- set source to a file
-- import data
obj.importFrom(ctx,'file','FILE_DIR','speaker.jpg');
-- check size
DBMS_OUTPUT.PUT_LINE('Length is ' || obj.getContentLength);
DBMS_OUTPUT.PUT_LINE('Source is ' || obj.getSource());
UPDATE pm.online_media p SET p.product_photo = obj WHERE p.product_id = 3501;
COMMIT;
END;
/
obj ORDSYS.ORDImage;
ctx RAW(64) :=NULL;
BEGIN
SELECT p.product_photo INTO obj FROM pm.online_media p
WHERE p.product_id = 3501 FOR UPDATE;
-- set source to a file
-- import data
obj.importFrom(ctx,'file','FILE_DIR','speaker.jpg');
-- check size
DBMS_OUTPUT.PUT_LINE('Length is ' || obj.getContentLength);
DBMS_OUTPUT.PUT_LINE('Source is ' || obj.getSource());
UPDATE pm.online_media p SET p.product_photo = obj WHERE p.product_id = 3501;
COMMIT;
END;
/