--動的SQL文の作成 WK_SQL := 'BEGIN :WK_RETURN:=' || TRIM(WK_PROC) || '(:WK_IN_PARA1' || ',:RTN_MESSAGE' || '); END;'; --動的SQL文の実行 EXECUTE IMMEDIATE WK_SQL USING OUT WK_RETURN,IN WK_IN_PARA1,OUT RTN_MESSAGE;
--動的SQL文の作成 WK_SQL := 'BEGIN :WK_RETURN:=' || TRIM(WK_PROC) || '(:WK_IN_PARA1' || ',:RTN_MESSAGE' || '); END;'; --動的SQL文の実行 EXECUTE IMMEDIATE WK_SQL USING OUT WK_RETURN,IN WK_IN_PARA1,OUT RTN_MESSAGE;