源码帖乱了,看这里
create or replace package pkg_book is
cursor cur1 is select * from books;
type bookcur is ref cursor return cur1%rowtype;
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur);
end pkg_book;
create or replace package body pkg_book is
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur) is
begin
open mybookcur for
select * from books where bid like '%:v_bid%';
end QueryBookInfo;
end pkg_book;
create or replace package pkg_book is
cursor cur1 is select * from books;
type bookcur is ref cursor return cur1%rowtype;
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur);
end pkg_book;
create or replace package body pkg_book is
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur) is
begin
open mybookcur for
select * from books where bid like '%:v_bid%';
end QueryBookInfo;
end pkg_book;
解决方案 »
- Oracle IO 异常
- 请高手帮忙写个oracle语句
- 急:关于xdb注册模式的路径问题
- oracel 9i的下载地址????
- group by a,b,c 能帮我解释下吗??
- 从来没见过这么古怪的问题
- 正常操作数据库N次后,现在 要恢复到其中的第J(j<N)次时的数据状态。问:用事务回滚可以实现么
- 求两个date型数据相差多少分钟用什么函数?
- 从AS400自带的DB2数据库中取出的汉字记录是乱码,请问如何还原?
- 高手指点:未锁定含有 LOB 值的行?????????????
- oracle9i客户盘装好后,出现奇怪错误,热心人快帮忙啊!
- 急呀急!!关于用低版本EXP.EXE放入高版本oracle里导数据的问题!!大家帮帮忙。。
昨晚刚遇到
--cursor cur1 is select * from books;
type bookcur is ref cursor;
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur);
end pkg_book;
/create or replace package body pkg_book is
procedure QueryBookInfo(v_bid in varchar,mybookcur in out bookcur) is
begin
open mybookcur for 'select * from books where bid like ''%'||v_bid||'%''';
end QueryBookInfo;
end pkg_book;
/