declare
	cmdline         varchar2(500);
	NUM 						NUMBER;
	begin
if :receiving.recno is not null then
	GO_BLOCK('rec_item_tmp');

  cmdline :='D:\q3system\ctl_files\rec_item.bat';
  host(cmdline);
  SELECT COUNT(*) INTO NUM FROM rec_item_tmp;
     IF NUM=0 THEN
        MESSAGE('NO DATA FOUND');
     ELSE
        MESSAGE('AMOUNT:'||to_char(num));  
				GO_BLOCK('REC_ITEM_TMP');
				EXECUTE_QUERY;    
     END IF;  
else
	message('NO RECNO');
	raise form_trigger_failure;
end if;
EXCEPTION WHEN OTHERS THEN MESSAGE('999-'||SQLERRM); °õ¦æ
end;

SQLLDR CONTROL=D:\Q3System\ctl_files\load_rec_item.ctl log=D:\Files_for_Q3system\need_files\rec_item.log bad=D:\Files_for_Q3system\need_files\rec_item.bad userid=YKK97/YKK08@NEW_Q3