procedure CareerManChangeSalGetAll(refOut out RefCursor) is begin open refOut for select a.id, a.NAME, a.NOWPOSITION_ID, to_char(a.NOWPOSITIONWHEN, 'yyyy-mm-dd') as NOWPOSITIONWHEN, to_char(a.JOINJOBTIME, 'yyyy-mm-dd') as JOINJOBTIME, a.OLDPOSITION_ID, to_char(a.OLDPOSITIONWHEN, 'yyyy-mm-dd') as OLDPOSITIONWHEN, a.NOWPOSITIONSAL, a.NOWLEVELSAL, a.AFTERPOSISAL, a.AFTERLEVELSAL, a.AFTERLEVEL_ID from RPT_CareerManChangeSal a; end CareerManChangeSalGetAll; 这个是我asp.net+oracle项目里的, 明白了吧?
上边是包体里的, 对应的包头里加上这两句: type RefCursor is ref cursor; procedure CareerManChangeSalGetAll(refOut out RefCursor) ;
begin
open refOut for
select a.id,
a.NAME,
a.NOWPOSITION_ID,
to_char(a.NOWPOSITIONWHEN, 'yyyy-mm-dd') as NOWPOSITIONWHEN,
to_char(a.JOINJOBTIME, 'yyyy-mm-dd') as JOINJOBTIME,
a.OLDPOSITION_ID,
to_char(a.OLDPOSITIONWHEN, 'yyyy-mm-dd') as OLDPOSITIONWHEN,
a.NOWPOSITIONSAL,
a.NOWLEVELSAL,
a.AFTERPOSISAL,
a.AFTERLEVELSAL,
a.AFTERLEVEL_ID
from RPT_CareerManChangeSal a;
end CareerManChangeSalGetAll;
这个是我asp.net+oracle项目里的, 明白了吧?
对应的包头里加上这两句:
type RefCursor is ref cursor;
procedure CareerManChangeSalGetAll(refOut out RefCursor) ;