Changing the PlsqlErrorStyle atttribute for EPG

I’ve been having some trouble with my Oracle XE + Apex 4.0 + EPG instance lately and the only way I could debug the error was by switching the way EPG produces the error messages in the web browser.

By default, EPG (Embedded PLSQL Gateway) outputs the web page rendering error messages in ApacheStyle, meaning that when a page results in error, the message displayed in the browser is similar to that output by an Apache HTTP Server (even if you’re not using one):

404 Not found

The requested URL was not found on this server

The way to change the error message style for EPG is by executing as SYS:

exec dbms_epg.set_dad_attribute(‘APEX’, ‘error-style’, ‘DebugStyle’);

The this parameter, PlsqlErrorStyle has the following values: ApacheStyle, ModplsqlStyle, DebugStyle

After executing the procedure above, the error message will be displayed as:

 

Mon, 13 Feb 2012 04:25:05 GMT ORA-04031: unable to allocate 40972 bytes of shared memory ("large pool","unknown object","koh-kghu sessi","pl/sql vc2") DAD name: blog PROCEDURE : f URL : http://XDB HTTP Server:8080/blog/f?p=100:1:1606755547143296::::P1_ARTICLE:2420 PARAMETERS : =========== p: 100:1:1606755547143296::::P1_ARTICLE:2420 ENVIRONMENT: ============ PLSQL_GATEWAY=WebDb GATEWAY_IVERSION=2 SERVER_SOFTWARE=Oracle Embedded PL/SQL Gateway/10.2.0.1.0 GATEWAY_INTERFACE=CGI/1.1 SERVER_PORT=8080 SERVER_NAME=XDB HTTP Server REQUEST_METHOD=GET QUERY_STRING=p=100:1:1606755547143296::::P1_ARTICLE:2420 PATH_INFO=/f SCRIPT_NAME=/blog REMOTE_HOST= REMOTE_ADDR=127.0.0.1 SERVER_PROTOCOL=HTTP/1.1 REQUEST_PROTOCOL=tcp REMOTE_USER=ANONYMOUS ORACLE_SSO_USER= OSSO_IDLE_TIMEOUT_EXCEEDED= OSSO_USER_GUID= HTTP_CONTENT_LENGTH=0 HTTP_CONTENT_TYPE= HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.46 Safari/535.11 HTTP_HOST=localhost:8080 HTTP_ACCEPT=text/html HTTP_ACCEPT_ENCODING=gzip HTTP_ACCEPT_LANGUAGE=nl HTTP_ACCEPT_CHARSET=ISO-8859-1 HTTP_COOKIE= HTTP_IF_MODIFIED_SINCE= HTTP_REFERER=http://localhost:8081/apex/f?p=100:1:1200241378811897::::P1_ARTICLE: HTTP_SOAPACTION= HTTP_ORACLE_ECID= HTTP_ORACLE_CACHE_VERSION= HTTP_AUTHORIZATION= WEB_AUTHENT_PREFIX= DAD_NAME=blog DOC_ACCESS_PATH=docs DOCUMENT_TABLE=wwv_flow_file_objects$ PATH_ALIAS=rest REQUEST_CHARSET=AL32UTF8 REQUEST_IANA_CHARSET=UTF-8 SCRIPT_PREFIX= HTTP_IF_MATCH= HTTP_CACHE_CONTROL= SOAP_BODY= HTTP_X_ORACLE_DEVICE_CLASS= HTTP_X_ORACLE_DEVICE_ORIENTATION= HTTP_X_ORACLE_DEVICE_MAXDOCSIZE= HTTP_X_ORACLE_DEVICE= HTTP_X_ORACLE_ORIG_ACCEPT= HTTP_X_ORACLE_ORIG_USER_AGENT= HTTP_X_ORACLE_USER_LOCALE= HTTP_X_ORACLE_USER_NAME= HTTP_X_ORACLE_USER_DISPLAYNAME= HTTP_X_ORACLE_USER_USERKIND= HTTP_X_ORACLE_USER_AUTHKIND= HTTP_X_ORACLE_USER_DEVICEID= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE1= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE2= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLASTLINE= HTTP_X_ORACLE_USER_LOCATION_BLOCK= HTTP_X_ORACLE_USER_LOCATION_CITY= HTTP_X_ORACLE_USER_LOCATION_COMPANYNAME= HTTP_X_ORACLE_USER_LOCATION_COUNTY= HTTP_X_ORACLE_USER_LOCATION_STATE= HTTP_X_ORACLE_USER_LOCATION_POSTALCODE= HTTP_X_ORACLE_USER_LOCATION_POSTALCODEEXT= HTTP_X_ORACLE_USER_LOCATION_COUNTRY= HTTP_X_ORACLE_USER_LOCATION_TYPE= HTTP_X_ORACLE_USER_LOCATION_X= HTTP_X_ORACLE_USER_LOCATION_Y= HTTP_X_ORACLE_SERVICE_HOME_URL= HTTP_X_ORACLE_SERVICE_PARENT_URL= HTTP_X_ORACLE_HOME_URL= HTTP_X_ORACLE_MODULE_CALLBACK_URL= HTTP_X_ORACLE_MODULE_CALLBACK_LABEL= HTTP_X_ORACLE_CACHE_USER=(null) HTTP_X_ORACLE_CACHE_SUBID= HTTP_X_ORACLE_CACHE_AUTH= HTTP_X_ORACLE_CACHE_DEVICE= HTTP_X_ORACLE_CACHE_LANG= HTTP_X_ORACLE_CACHE_ENCRYPT= HTTP_X_ORACLE_ASSERT_USER=

 

Leave a Reply