create or replace PACKAGE get_bom
as
TYPE bom is Ref cursor;
procedure example(bom_cr OUT BOM);
end get_bom;
/
create or replace PACKAGE BODY get_bom
AS
procedure example(
bom_cr OUT BOM
) as
begin
open bom_cr for select * from test;
end example;
end get_bom;
/
set serveroutput on
declare
TYPE bom is Ref cursor;
lvC bom;
lv bom;
lvAA number(5);
begin
get_bom.example(lvC);
LOOP
FETCH lvC INTO lvAA;
EXIT WHEN lvC%NOTFOUND;
dbms_output.put_line(lvAA);
end loop;
end;/*
SQL> desc a
AA NUMBER(2)
*/
as
TYPE bom is Ref cursor;
procedure example(bom_cr OUT BOM);
end get_bom;
/
create or replace PACKAGE BODY get_bom
AS
procedure example(
bom_cr OUT BOM
) as
begin
open bom_cr for select * from test;
end example;
end get_bom;
/
set serveroutput on
declare
TYPE bom is Ref cursor;
lvC bom;
lv bom;
lvAA number(5);
begin
get_bom.example(lvC);
LOOP
FETCH lvC INTO lvAA;
EXIT WHEN lvC%NOTFOUND;
dbms_output.put_line(lvAA);
end loop;
end;/*
SQL> desc a
AA NUMBER(2)
*/
解决方案 »
- oracle 包含条件
- 数据库备份问题
- 寻熟悉ORACLE FORM的高手
- 数据字典在SGA区的哪一个组件中缓存
- RMAN change命令求答
- 我在oracle建表的时候,提示no previliges on tablespace tpl
- 判断题
- oracle9刻的盘能用吗?
- 求字符提取的代码!高手帮帮忙!急!在线等!
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exit是进入LQLPLUS的错误提示,请问这是什么错误,急!急
- 如何对Clob对象Append?
- 高分求教:请问怎样把字段里的回车符在sql中去掉。急!在线等待。。。
sqlplus里这么写:
variable c refcursor
exec [ProcName] (:c);
print c
你的方法调用提示成功!在C++ builder 里好象没有varialble这个类型,我该怎么声名这个变量?
没用过C++ Builder, 但是各种开发语言,我想应该都能支持存储过程
返回结果集吧.
v_rc get_bom.bom;
v_field_Code data_center.field_Code%type;
v_field_name data_center.field_name%type;
begin
open v_rc;
loop
fetch v_rc into v_field_Code,v_field_name;
exit when v_rc%notfound;
dbms_output.put_line(v_field_Code||v_field_name);
end loop;
close v_rc;
end;
/