create or replace package testproc2
is type type2 is ref cursor;
procedure proc2(usercode in number,userlist out type2);
end testproc2;Create or replace package body testproc2
procedure proc2(usercode in number,userlist out type2)
as
begin
open userlist for
select * from lduser where rownum <= usercode;
end proc2;
end testproc2;
解决方案 »
- 连接的问题
- 如何把测试机中的数据库导到本地?
- 请问一个判断时间重复的算法
- 机器上已经安装SQL Sever2005,请问在机器上再安装Oracle9i或Oracle10会不会有冲突?
- 如何提高批量更新某一列的速度??
- win7 x64下安装32bit的ORACLE遇到的问题.
- 数据到出问题!我用的图形界面,活动栏内停留在 “已提交“ 状态,就没有反映了?
- 请教如何用c连接oracle数据库?
- 求助
- 数据库恢复报错
- Sql developer连接Oracle一直测试连接也没报错,就是连不上!
- 送分100分:请问SQL SERVER2000中的master、pubs、northwind等数据库,在ORACLE中有没有同样的东西
is type type2 is ref cursor;
procedure proc2(usercode in number,userlist out type2);
end testproc2;Create or replace package body testproc2 is
procedure proc2(usercode in number,userlist out type2)
as
begin
open userlist for
select * from lduser where rownum <= usercode;
end proc2;
end testproc2;
写as也可以.
Line: 6
Text: Create or replace package body testproc2 is加上之前和之后 都提示我这个 不知道原因
。
这样,你第一个packeage执行后 要加一个“/”
即:
create or replace package testproc2
is type type2 is ref cursor;
procedure proc2(usercode in number,userlist out type2);
end testproc2;
/Create or replace package body testproc2 is
procedure proc2(usercode in number,userlist out type2)
as
begin
open userlist for
select * from lduser where rownum <= usercode;
end proc2;
end testproc2;
create or replace package testproc2
is type type2 is ref cursor;
procedure proc2(usercode in number,userlist out type2);
end testproc2;/Create or replace package body testproc2 as
procedure proc2(usercode in number,userlist out type2)
as
begin
open userlist for
select * from lduser where rownum <= usercode;
end proc2;
end testproc2;