17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE TESTHANSHU(TEST_FUN IN VARCHAR2) IS
/*---游标定义--------------------------*/
N_T VARCHAR2(255);
T_NUM NUMBER(8, 2) := 0;
BEGIN
N_T := 'select ' || TEST_FUN || '(123.6546,2) from dual';
EXECUTE IMMEDIATE N_T
INTO T_NUM;
DBMS_OUTPUT.PUT_LINE('Result : ' || T_NUM);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Result : ' || N_T || SQLERRM);
END TESTHANSHU;
SQL> set serveroutput on;
SQL> exec TESTHANSHU('round');
Result : 123.65
PL/SQL procedure successfully completed
SQL>