If you are unable to compile your reports or plls in Oracle 10g Version, due to the error like
PL SQL ERROR 201: SRW.___ must be declared, then check the existence of the following file and its privilege:
rwrun.jar in /Oracle10gAS/reports/jlib folder.
Where Oracle10gAS is the folder where 10g Application server is installed.
You will normally get this error only in UNIX/Linux flavors, because this is related to privilege rights. If you are getting this error in Windows also, then it is quietly possible that the file is missing.
The file must have the privilege 755 or -rwx-r-x-r-x.
PL SQL ERROR 201: SRW.MESSAGE must be declared
Posted by
Anantha Narayanan
on Monday, April 23, 2007
/
Labels:
ORA-Errors,
OS Level,
Reports,
Troubleshooting