declare
function sf_insert_3012(p_table_name varchar2)
return boolean as
begin
insert into p_table_name
(book_no
)
values (nvl(lv_sep_new_book_no,lv_new_book_no));
return (true);
exception
when others then
return (false);
end;
begin
lv_flag = sf_insert_3012('mft3012') ;
end;紅線那該怎麼寫?
function sf_insert_3012(p_table_name varchar2)
return boolean as
begin
insert into p_table_name
(book_no
)
values (nvl(lv_sep_new_book_no,lv_new_book_no));
return (true);
exception
when others then
return (false);
end;
begin
lv_flag = sf_insert_3012('mft3012') ;
end;紅線那該怎麼寫?
EXECUTE IMMEDIATE 'insert into ' || p_table_name || .....;