Home » Developer & Programmer » Reports & Discoverer » How can Report to use execute immediate without error (EB 12.0.4, UNIX 5.10)
How can Report to use execute immediate without error [message #416449] Sun, 02 August 2009 23:11 Go to next message
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 Go to previous message
cookiemonster
Messages: 12422
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?
Previous Topic: Comma in the data creating porblem for excel file (csv) generation
Next Topic: report ask user to save pdf file before opening pdf
Goto Forum:
  


Current Time: Sat Dec 10 01:31:07 CST 2016

Total time taken to generate the page: 0.08659 seconds