Procedure
过程
CREATE OR REPLACE PROCEDURE GET_ALL_ITEM_TYPE
(
cur_OUT OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN cur_OUT FOR
SELECT * FROM PG_ITEM_TYPE ;
END GET_ALL_ITEM_TYPE;
CREATE OR REPLACE PROCEDURE GEProcedure
过程
CREATE OR REPLACE PROCEDURE GET_ALL_ITEM_TYPE
(
cur_OUT OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN cur_OUT FOR
SELECT * FROM PG_ITEM_TYPE ;
END GET_ALL_ITEM_TYPE;
CREATE OR REPLACE PROCEDURE GE