oracle使用一天后的总结: 不人性化.安装文件巨大无比不说,配置巨恶心,时不时来个莫名其妙的错.远远不如mssql来的方便.经常莫名其妙登录不上.真是火大.自身所带的sql plus 巨烂无比.感觉是个八十年代下的东西.如果要开发存储过程,函数等真是太不方便了.真不知oracle公司是怎么开发出这么个东西的.
关于函数中游标参数的问题, 编译就是通不过,是为什么?--创建包头 create or replace package hsusptype is type mycursor is ref cursor;end hsusptype; /--创建包体 create or replace package body hsusptype is type mycursor is ref cursor;
end hsusptype; /create or replace function service_req_fundinfo ( p_cursor output hsusptype.mycursor /*编译到这一行就报错,为何? */ ) return integer as
begin open p_cursor for select error_no as error_no, error_info as error_info from dual; return 0;end service_req_fundinfo; /
http://211.99.196.144:8090/forum1/frontshow/dispbbs.jsp?boardid=108&id=4038刚开始学 Oracle的时候,和楼主的认为一样~ 但... 哈~(时间可以证明一切)
create or replace package hsusptype is type mycursor is ref cursor;end hsusptype;
/--创建包体
create or replace package body hsusptype is type mycursor is ref cursor;
end hsusptype;
/create or replace function service_req_fundinfo
(
p_cursor output hsusptype.mycursor /*编译到这一行就报错,为何? */
)
return integer
as
begin
open p_cursor for select error_no as error_no, error_info as error_info from dual;
return 0;end service_req_fundinfo;
/