还有如何把下面的两个sql中的存储过程分别改写为oracle中的,谢谢CREATE Procedure bb as
SELECT * FROM users
return
GOCREATE Procedure aa (@userID int) AS
SELECT * FROM users WHERE userID=@userID
return
GO
SELECT * FROM users
return
GOCREATE Procedure aa (@userID int) AS
SELECT * FROM users WHERE userID=@userID
return
GO
is
type ResultData is ref cursor;
procedure bb(Rst out ResultData);
procedure aa( auserid in int,Rst out ResultData);
end PKG_Test;
create or replace package body PKG_Test
is
procedure bb(Rst out ResultData)
is
begin
open Rst for select * from users;
end;
procedure aa( auserid in int,Rst out ResultData)
is
begin
open Rst for select * from users where userid=auserid;
end;
end PKG_Test;