| How can Report to use execute immediate without error [message #416449] |
Sun, 02 August 2009 23:11  |
wkngan
Messages: 1
Registered: August 2009
|
Junior Member |
|
|
Hi,
Appreciate could get some advice from all Guru here. Currently I am trying to perform a tuning for a report. I had created a Package to execute the following action 'execute IMMEDIATE 'alter session set filesystemio_options = "asynch"';' at the report on
function BeforeReport return boolean is
begin
xxxper_payroll_reg_10g.degrade_optimizer;
srw.user_exit('FND SRWINIT');
return (TRUE);
end;
I have managed to compiled the report without any error but its error on submitting the job at the application level. Follwoing is the error msg:
Enter Password:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-00922: missing or invalid option
ORA-06512: at "APPS.XXXPER_PAYROLL_REG_10G", line 8
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-00922: missing or invalid option
ORA-06512: at "APPS.XXXPER_PAYROLL_REG_10G", line 8
Thank you and best rgds,
WK.
|
|
|
|
| Re: How can Report to use execute immediate without error [message #416524 is a reply to message #416449] |
Mon, 03 August 2009 04:12  |
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
You can't set that parameter at session level:
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 3 09:59:52 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.2.0 - 64bit Production
SQL> sho parameter filesystemio_options
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string asynch
SQL> alter session set filesystemio_options = "asynch";
alter session set filesystemio_options = "asynch"
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL>
Why do you think you want to change it?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
