/*包头*/
create or replace package pk_breackitem
is
type pak_sel is record
(
re_itemnr number(11),
re_breackdate number(11),
re_breackqty number(30),
re_breackmoney number(30)
);
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
return pak_sel; end pk_breackitem;
.................................................................
/*包体*/
create or replace package body pk_breackitem
is
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
is
breack pak_sel;
begin
select itemnr,breackdate,breackqty,breackmoney into breack from hr.breackitem;
return breack;
end f_sel_breack;
end pk_breackitem;
create or replace package pk_breackitem
is
type pak_sel is record
(
re_itemnr number(11),
re_breackdate number(11),
re_breackqty number(30),
re_breackmoney number(30)
);
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
return pak_sel; end pk_breackitem;
.................................................................
/*包体*/
create or replace package body pk_breackitem
is
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
is
breack pak_sel;
begin
select itemnr,breackdate,breackqty,breackmoney into breack from hr.breackitem;
return breack;
end f_sel_breack;
end pk_breackitem;
解决方案 »
- Oracle各种锁区别
- oracle设置列间距?????
- 这个问题怎么解决啊
- 跪求一个解决方法~~!请大家帮忙 别让我被开除...
- 出现错误提示:ORA-04031: 无法分配 8192 字节的共享内存 ("large pool","unknown object","sga heap","multiblock rea")
- 初学oracle,请指点什么意思?
- java如何将oracle里的一个方案的所有数据导到另一个方案里
- 新手关于xp下安装oracle的问题。
- oracle与vb的问题
- 请教:在一张表中怎么取出A列大于B列的所有行
- 快春节了,不知还有没有人帮我解决这个触发器的写法!在线等待!
- 关于某个索引未成功利用到的问题?
is
out_rc sys_refcursor;
type pak_sel is record
(
re_itemnr number(11),
re_breackdate number(11),
re_breackqty number(30),
re_breackmoney number(30)
);
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
return pak_sel;end pk_breackitem;
.................................................................
/*包体*/
create or replace package body pk_breackitem
is
out_fun out_rc;
function f_sel_breack(fu_itemr,hr.breackitem.itemnr%type)
is
breack pak_sel;
begin
open out_rc;
select itemnr,breackdate,breackqty,breackmoney from hr.breackitem
where itemnr=fu_itemr;
fetch out_rc into breack;
return breack;
end f_sel_breack;
end pk_breackitem;...............................................................................
我这样只能包规范可以创建。包体不能通过有编译错误。我用 SHOW ERROR 显示,没有错误。我那错了?