Verify type parameters call in Oracle procedure

create or replace procedure e_name 2 ( 3 p_ids in varchar2, 4 p_name in varchar2, 5 p_csr out sys_refcursor 6 ) as 7 begin 8 open p_csr for 9 select object_name, owner, object_type 10 from all_objects 11 where object_name = upper(p_name) 12 and owner = upper(p_ids); 13 end; 14 /  

create or replace procedure e_name 2 ( 3 p_ids in varchar2, 4 p_name in varchar2, 5 p_csr out sys_refcursor 6 ) as 7 begin 8 open p_csr for 9 select object_name, owner, object_type 10 from all_objects 11 where object_name = upper(p_name) 12 and owner = upper(p_ids); 13 end; 14 /  
create or replace procedure e_name
  2      (
  3      p_ids in varchar2,
  4      p_name in varchar2,
  5      p_csr out sys_refcursor
  6      ) as
  7  begin
  8      open p_csr for
  9         select object_name, owner, object_type
 10         from all_objects
 11         where object_name = upper(p_name)
 12         and owner = upper(p_ids);
 13  end;
 14  /

 

Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments