都可以使用 CALL 参数来调用相应的函数或过程 :

V_SQL_F := 'CALL TEST_FUNC_P(:P_1) INTO :V_RESULT';

V_SQL_P := 'CALL TEST_CALL_P(:P_1)';

EXECUTE IMMEDIATE V_SQL_F

USING IN V_I_P1, OUT V_RESULT;

EXECUTE IMMEDIATE V_SQL_P

USING IN V_I_P1;

I believe that we are who we choose to be. Nobody‘s going to come and save you, you‘ve got to save yourself. 我相信我们成为怎样的人是我们自己的选择。没有人会来拯救你，你必须要自己拯救自己。