ref弱类型游标简析
类别:Oracle数据库 作者:码皇 来源:互联网 点击:
ref弱类型游标简析create or replace procedure RefCursorastype toys_curtyp is ref cursor; cur toys_curtyp; stmt_str VARCHAR2(200); v_TAID number; v_taname VARCHAR2(
ref弱类型游标简析 create or replace procedure RefCursor as type toys_curtyp is ref cursor; cur toys_curtyp; stmt_str VARCHAR2(200); v_TAID number; v_taname VARCHAR2(100); v_bqid number; begin www.2cto.com stmt_str :='select TAID, taname, bqid from table3'; OPEN cur FOR stmt_str; loop FETCH cur INTO v_TAID, v_taname,v_bqid; exit when cur%notfound; dbms_output.put_line(v_TAID||':'||v_taname|| ':' ||v_bqid); end loop; CLOSE cur; end RefCursor;
作者 勇往直前102002
相关热词搜索:
ref 弱 类型 游标