Sql Server 與 Oracle 比較(store procedure)

有答案了:
CREATE OR REPLACE  PACKAGE PKG_TEST  as
type cursor_test is ref cursor;
end PKG_TEST;CREATE OR REPLACE  PROCEDURE RPT_TEST  (
  v_p1 in char,
  v_cur_test out PKG_TEST.cursor_test
)
as
begin
   open v_cur_test for select * from TEST where NAME=v_p1;
end;