PlsqlErrorStyle
Specifies the Error Reporting Mode for errors generated in mod_plsql. This parameter accepts the following values:
ApacheStyle
(default): In this mode, mod_plsql indicates to OHS what HTTP error was encountered. OHS then generates the error page. This can be used with OHS's ErrorDocument directive to produce customized error messages.ModplsqlStyle
: mod_plsql generates the error pages, usually a short message indicating the PL/SQL error that was encountered and PL/SQL exception stack if any e.g. "scott.foo PROCEDURE NOT FOUND"DebugStyle
: This mode enhances the error message with more details thanModplsqlStyle
. mod_plsql provides more details about the URL, parameters and also produces server configuration information. This mode is for debugging purposes only. Do not use in a production system since displaying internal server variables could be a security risk.
- Syntax:
- PlsqlErrorStyle ApacheStyle
- PlsqlErrorStyle ModplsqlStyle
- PlsqlErrorStyle DebugStyle
- Default:
- ApacheStyle
- Example:
- PlsqlErrorStyle ModplsqlStyle
Tips for PlsqlErrorStyle
With this parameter set to ApacheStyle
and you call the procedure doc
that actually does not exists, you get an output like this:
Not Found
The requested URL /pls/uti/doc was not found on this server. ...
With ModplsqleStyle
set in the DAD you will get:
Tue, 28 Jan 2014 00:22:25 GMT
doc: PROCEDURE DOESN'T EXIST
And with a value of DegugStyle
the outcome will look like this:
Tue, 28 Jan 2014 00:33:40 GMT
doc: PROCEDURE DOESN'T EXIST
DAD name: uti
PROCEDURE : doc
URL : //oracle.com:80/pls/uti/doc
PARAMETERS :
===========
ENVIRONMENT:
============
PLSQL_GATEWAY=WebDb
GATEWAY_IVERSION=2
SERVER_SOFTWARE=Oracle-Application-Server-10g/11.7.4.3.1 Oracle-HTTP-Server
GATEWAY_INTERFACE=CGI/1.1
SERVER_PORT=80
SERVER_NAME=oracle.com
REQUEST_METHOD=GET
QUERY_STRING=
PATH_INFO=/doc
SCRIPT_NAME=/pls/uti
REMOTE_HOST=
REMOTE_ADDR=137.254.120.150
SERVER_PROTOCOL=HTTP/1.1
REQUEST_PROTOCOL=HTTP
REMOTE_USER=uti
ORACLE_SSO_USER=
HTTP_CONTENT_LENGTH=
HTTP_CONTENT_TYPE= ...
btw: In older versions, this parameter was called error_style