Tips about Stored Procedures

To pass the parameter to stored procedure to get it executed at the run time,
param2 varchar2(50);
BEGIN keyword as param2 varchar2(50);
param2 := chr(39)||replace(param1,’,’,”’,”’)||chr(39);
select * from hr.employees where job in (param2);
as
select * from hr.employees where job in (param2)

Read Full Post »