直接上代码
CREATE OR REPLACE PROCEDURE GETPRICELISTZGY(PARAMID IN VARCHAR2,
RESULT_CURSO OUT SYS_REFCURSOR) IS
W_COUNT NUMBER;
S_SQL VARCHAR2(2000);
BEGIN
SELECT COUNT(1)
INTO W_COUNT
FROM ADMIN_ACCOUNT AW
WHERE AW.SNO = 1