CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; END pkg_test; / CREATE PROCEDURE dbo.visit_GetProblemDetail(appno varchar2,p_rc out pkg_test.myrctype)AS str varchar2(50); begin str:='SELECT * FROM visit_problem_item where appno='||appno; open p_rc for str; end; /
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
CREATE PROCEDURE dbo.visit_GetProblemDetail(appno varchar2,p_rc out pkg_test.myrctype)AS
str varchar2(50);
begin
str:='SELECT * FROM visit_problem_item where appno='||appno;
open p_rc for str;
end;
/