是这种EXECUTE IMMEDIATE语句吧
CREATE OR REPLACE PROCEDURE proc(cate IN INT, time IN DATE) AS
DECLARE
str_sql varchar := ‘SELECT NAME,PUBLISHER from PRODUCTION.PRODUCT WHERE
PRODUCT_SUBCATEGORYID = ? AND PUBLISHTIME> ?’;
BEGIN
EXECUTE IMMEDIATE str_sql USING cate,time;
EXCEPTION
WHEN OTHERS THEN PRINT ‘error’;
END;
/
CALL proc(4, ‘2001-01-01’);