要求在在oracle 10G中运行,传入一个参数,返回一个数据集,跟下列SQL server 中的效果一样
create procedure prc_aaselect
(@id varchar(10))
as
select * from sales where stor_id=@id用ASP.NET能执行该存储过程!
解决马上结帐!
create procedure prc_aaselect
(@id varchar(10))
as
select * from sales where stor_id=@id用ASP.NET能执行该存储过程!
解决马上结帐!
2 TYPE T_CURSOR IS REF CURSOR;
3 END;
4 /
程序包已创建。SQL> CREATE OR REPLACE PROCEDURE P_QUERY_DEPT(P_CURSOR OUT P_DEFINE_CURSOR.T_CURSOR) AS
2 BEGIN
3 OPEN P_CURSOR FOR SELECT * FROM DEPT;
4 END;
5 /
过程已创建。SQL> CREATE OR REPLACE FUNCTION F_QUERY_EMP RETURN P_DEFINE_CURSOR.T_CURSOR AS
2 V_RESULT P_DEFINE_CURSOR.T_CURSOR;
3 BEGIN
4 OPEN V_RESULT FOR SELECT * FROM EMP;
5 RETURN V_RESULT;
6 END;
7 /
函数已创建。