Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLW-0518

923264May 1 2012 — edited May 1 2012
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2012
Added on May 1 2012
4 comments
1,176 views