vn_count;
vs_name := "";
my_sql:=select count(*) from dual d where d.name=:x
EXECUTE IMMEDIATE my_sql INTO vn_count USING IN vs_name;
vn_count;
vs_name := "";
my_sql:=select count(*) from dual d where d.name=:x
EXECUTE IMMEDIATE my_sql INTO vn_count USING IN vs_name;