写一个过程,供程序调用,且有返回值
暂时记录此过程,完成后再完善
CREATE OR REPLACE PROCEDURE getUserList(
userid varchar2,
userRow out tbl_user%rowtype )
as
--DECLARE
--结构定义成公共的外部结构,也可以作返回值用吧?
TYPE TB_USER_STRUCT IS RECORD(
userid VARCHAR2(50),
name VARCHAR2(50),
blog VARCHAR2(50));
myUser TB_USER_STRUCT;
--userRow tbl_user%rowtype;
begin
select * into userRow from tbl_user where userid =userid;
select * into myUser from tbl_user where userid =userid;
end;
暂时记录此过程,完成后再完善
CREATE OR REPLACE PROCEDURE getUserList(
userid varchar2,
userRow out tbl_user%rowtype )
as
--DECLARE
--结构定义成公共的外部结构,也可以作返回值用吧?
TYPE TB_USER_STRUCT IS RECORD(
userid VARCHAR2(50),
name VARCHAR2(50),
blog VARCHAR2(50));
myUser TB_USER_STRUCT;
--userRow tbl_user%rowtype;
begin
select * into userRow from tbl_user where userid =userid;
select * into myUser from tbl_user where userid =userid;
end;