meimao5211

摘要： c#调用oracle存储过程返回数据集2008-12-20 10:59:57|分类：net|字号订阅CREATE OR REPLACE PACKAGE pkg_tableTypeIS type Tabletype is ref cursor; PROCEDURE SP_CPZD ( CPNO IN VARCHAR2, STATUS IN VARCHAR2, t_sql out Tabletype );END;CREATE OR REPLACE package BODY pkg_tableTypeisPROCEDURE SP_CPZD(CPNO IN VARCHAR2,STATUS IN VAR 阅读全文

摘要： 在sqlplus中建立如下的内容：1、程序包SQL> create or replace package types 2 as 3 type cursorType is ref cursor; 4 end; 5 /程序包已创建。2、函数SQL> create or replace function sp_ListEmp return types.cursortype 2 as 3 l_cursor types.cursorType; 4 begin 5 open l_cursor for select id, title from cf_news order by id;--表的名 阅读全文

摘要： c#调用oracle存储过程返回数据集2008-12-20 10:59:57|分类：net|字号订阅CREATE OR REPLACE PACKAGE pkg_tableTypeIS type Tabletype is ref cursor; PROCEDURE SP_CPZD ( CPNO IN VARCHAR2, STATUS IN VARCHAR2, t_sql out Tabletype );END;CREATE OR REPLACE package BODY pkg_tableTypeisPROCEDURE SP_CPZD(CPNO IN VARCHAR2,STATUS IN VAR 阅读全文