Coba dicheck status dari indexes-nya: SQL> SELECT index_name, status FROM dba_indexes WHERE table_name = 'YAN_DIRJPG_TAB';
bw --- In [email protected], yandha perdana <yandha.jperd...@...> wrote: > > 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 >
