Contoh, kalau pakai BLOB datatype ....
DROP TABLE test_blob CASCADE CONSTRAINTS
/
CREATE TABLE test_blob (
id NUMBER(15)
, file_name VARCHAR2(1000)
, ms_docs BLOB
, timestamp DATE
)
/
CREATE OR REPLACE DIRECTORY
MS_DOC_DIR
AS
'C:\MS_DOC_DIR' -- lokasi files doc nya berada
/
CREATE OR REPLACE PROCEDURE Load_From_File_doc
AS
dest_loc BLOB;
src_loc BFILE := BFILENAME('MS_DOC_DIR', 'my_ms_doc_file.doc');
BEGIN
INSERT INTO test_blob (id, file_name, ms_docs, timestamp)
VALUES (1001, 'my_ms_doc_file.doc', empty_blob(), sysdate)
RETURNING image INTO dest_loc;
DBMS_LOB.OPEN(src_loc, DBMS_LOB.LOB_READONLY);
DBMS_LOB.OPEN(dest_loc, DBMS_LOB.LOB_READWRITE);
DBMS_LOB.LOADFROMFILE(
dest_lob => dest_loc
, src_lob => src_loc
, amount => DBMS_LOB.getLength(src_loc));
DBMS_LOB.CLOSE(dest_loc);
DBMS_LOB.CLOSE(src_loc);
COMMIT;
END;
/
SQL> EXECUTE Load_From_File_doc
CMIIW,
Bowo
--- In [email protected], Ade Wahyu <[EMAIL PROTECTED]>
wrote:
>
> Dear Master Oracle
>
> Tolongin donk....Kasih Tau sintaks untuk load file doc di Oracle 9i
> using PL/SQL.......
>
> Please...
>
> Thanks
>
>
>
> Send instant messages to your online friends
http://uk.messenger.yahoo.com
>
> [Non-text portions of this message have been removed]
>
