declare aa number(15,2); l_cnt varchar2(200); i_yr int :=11; i_curCode varchar2(100) :='001'; i_vDate date := sysdate; i_valExpr varchar2(100) := 'haha'; i_branchNo varchar2(100) := '00'; begin l_cnt := 'Ns_Gls_AutoVal(132,:1,:2,:3,:4)'; execute immediate 'select ' || l_cnt || ' from dual' into aa using i_curCode,i_vDate,i_valExpr,i_branchNo; dbms_output.put_line(aa); end;