create or replace procedure MyPre_IMPORTMap(nMapid in varchar2,
nFilename in varchar2, nFilecon out blob,nlastfile in number,
nfilelevel in number )is
num number;
recordnum number;
begin
select SEQ_SYS_FILE_NUM.NEXTVAL into num from dual;
select count(sys_file.file_num) into recordnum from sys_file
where sys_file.file_name = nFilename and sys_file.map_id = nMapid;
if recordnum > 0 then
begin
update sys_file set sys_file.file_con = empty_blob()
where sys_file.file_name = nFilename
and sys_file.map_id = nMapid
returning sys_file.file_con
into nFilecon;
end;else
begin
insert into sys_file values(num,nMapid,nFilename,empty_blob(),
nlastfile,nfilelevel)
returning sys_file.file_con
into nFilecon;
end;end if;
end MyPre_IMPORTMap