hozarares Posted February 29, 2012 Report Posted February 29, 2012 What is APEX?[From Oracle.com] Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.InfrastructureThis blog is developed in APEX 4.0.1.00.03 with an ORACLE XE database. The Oracle instance is running on a dedicated servers hosted in the USA and has the following specs: AMD Dual Core 2x2,2 GHz, 2 GB DDR2 RAM and a 250 GB drive. We use Linux Centos 5 64 bit version operating system. We are using the Embedded PLSQL Gateway (EPG) and Apache HTTP server.Exemplu: usor de implementat !##############################################################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 foundThe requested URL was not found on this serverThe 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, DebugStyleAfter executing the procedure above, the error message will be displayed as:Mon, 13 Feb 2012 04:25:05 GMTORA-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=********* 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://www.apexninjas.com/blog/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=Sursa:http://www.apexninjas.com/blog/f?p=100:1:1202975706803231::::: Quote
