How to replace the string which has passed in procedure while using EXECUTE IMMEDIATE in Oracle?
create or replace procedure Sample(rowsize number)
is
    v_result varchar2(100);
    v_str varchar2(200);
begin
    v_str := 'Select rtrim(legl_ent_name) || '' | '' ||rtrim(legl_ent_prd_grp) as heirarchy from legl_ent_regn where rownum &lt; :1';
    EXECUTE IMMEDIATE v_str USING rowsize;
    DBMS_OUTPUT.PUT_LINE(rowsize);
end;