ApexNinjas (ORACLE APEX + exemplu implementare)

[hozarares]

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.

Infrastructure

This 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 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=*********

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:::::