By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create table emp (id int,name varchar2(20));
BEGIN
insert into emp values(1,'Jack');
insert into emp values(2,'John');
insert into emp values(3,'Jams');
END;
/
1 rows affected
create table ano(id int,rule varchar2(4000));
insert into ano values(
1,
'declare
v_cnt number;
begin
select count(1) into v_cnt from emp where id = :1;
if(v_cnt>1)
then :2 := ''true'';
else :2 := ''false'';
end if;
end;'
);
1 rows affected
create procedure pr_ano(
i_id ANO.ID%TYPE
)
IS
v_rule ANO.RULE%TYPE;
v_out VARCHAR2(5);
BEGIN
SELECT rule INTO v_rule FROM ano WHERE id = i_id;
EXECUTE IMMEDIATE v_rule USING 1, OUT v_out;
DBMS_OUTPUT.PUT_LINE(v_out);
END;
/
SELECT * FROM USER_ERRORS;
BEGIN
DBMS_OUTPUT.ENABLE();
pr_ano(1);
END;
/
1 rows affected
dbms_output:
false