给各位汇报一下,我的问题基本解决了。执行提交report的程序应该这么写:
procedure submit_report is
req_id number;
begin
req_id := fnd_request.submit_request('XXX','XXINREPORT',null,null,null,
fnd_profile.value('organization_id'), name_in('TOLINES_BLK.REQUEST_NUMBER'),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0), chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),
chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0),chr(0));
if (req_id = 0) then
-- Handle submission error
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
-- null;
else
commit;
end if;
end submit_report;
原来编译时报错,是因为在PL/SQL中要把所有的参数全部写出来才行,因为PL/SQL的版本太低了,因此就是要写105个参数,如上所示。
在此,谢谢各位对我的帮助! |