pak ujang dan pak yulius terima kasih penjelasannya
sekarang saya coba buat Oracle directory object..
create or replace directory yan_dirjpg as 'C:\oracle'
udah buat table juga
create table yan_dirjpg_tab (
id number,
archive_number varchar2(255),
file_upload varchar2(20),
filesize varchar2(50),
desc_file varchar2(50),
content bfile,
constraint jpg_pk primary key (id))
sequence dan index juga saya coba buat
saya coba buat procedure
create or replace procedure loadimg_proc
(
p_file_name in yan_dirjpg_tab.archive_number%type,
p_upload_date in yan_dirjpg_tab.FILE_UPLOAD%type,
p_filesize in yan_dirjpg_tab.filesize%type,
p_desc in yan_dirjpg_tab.DESC_FILE%type
)
AS
index_name varchar2(20) := 'yan_dirjpg_idx';
begin
insert into yan_dirjpg_tab
(id, archive_number, file_upload, filesize, desc_file, content)
values (yan_dirjpg_seq.nextval, p_file_name, p_upload_date, p_filesize, p_desc,
BFILENAME('yan_dirjpg',p_file_name));
commit;
end;
/
tapi pas di jalannin procedurenya ada error
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "SYSTEM.LOADIMG_PROC", line 11
ORA-06512: at line 1
saya tidak mengerti pas dibagian ini, mohon inputannya pak..
Terima kasih
