PLW-0518
923264May 1 2012 — edited May 1 2012Hi
I am getting the following warning when I am compliling the following procedure.Can anyone let me know why I am getting this warning:
create or replace procedure load_proc_name is
begin
insert into table_name
select x. column1,concat(x.column 2,x.column 3) from
table x
where x.column 1 in ('304','303','221','222','223','215','216','217','218','207','208','209','210','211','212','213') and
(x.column 2 in ('yyy','zzz') or
x.column 3 ='bbb');
commit;
end load_proc_name;
[Warning] PLW-05018 (1: 1): PLW-05018: unit LOAD_tablename omitted optional AUTHID clause; default value DEFINER used
Thanks in Advance!!
Edited by: User28 on May 1, 2012 1:28 PM