我在packages中调用的procedure,
PROCEDURE PoToExcel
(VSYSNO IN varchar2,
VCURSOR OUT T_CURSOR
) IS
VToExcel T_CURSOR;
VSTR LONG;
BEGIN
VSTR := 'SELECT ... WHERE POH.SYSNO IN ('||VSYSNO||')'
OPEN VTOEXCEL FOR VSTR;
VCURSOR:=VTOEXCEL;
END;
--VSTR有很长(可能有上10万个字符), 会出现ORA-01795ORA-01795: maximum number of expressions in a list is 1000 错
弄了好久都没法搞定, 请大家帮帮我. 感谢!
PROCEDURE PoToExcel
(VSYSNO IN varchar2,
VCURSOR OUT T_CURSOR
) IS
VToExcel T_CURSOR;
VSTR LONG;
BEGIN
VSTR := 'SELECT ... WHERE POH.SYSNO IN ('||VSYSNO||')'
OPEN VTOEXCEL FOR VSTR;
VCURSOR:=VTOEXCEL;
END;
--VSTR有很长(可能有上10万个字符), 会出现ORA-01795ORA-01795: maximum number of expressions in a list is 1000 错
弄了好久都没法搞定, 请大家帮帮我. 感谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货