Application Express

PreviousNext

Table of Contents

Forms Conversion

Oracle Application Express provides a forms conversion utility. This enables developers to export Oracle Forms based applications to XML using the standard Forms utility, then import the XML into Oracle Application Express.

Once loaded into a Forms conversion project, a subset of the functionality can be automatically generated as an Oracle Application Express application. For logic that is not automatically converted, Oracle Application Express enables developers to track the manual migration of client-side Forms logic.

Access Migration

The Oracle Application Express Migration Workshop assists customers in migrating Microsoft Access applications to Oracle Application Express. It works in harmony with the Oracle SQL Developer Migration Workbench to provide a total solution for your Access Migration requirements. You first use SQL Developer Migration Workbench to migrate your schema definition and data and then use the Oracle Application Express Migration Workshop to migrate your Access forms and reports. The last step is refining your new application taking advantage of all the power and capabilities of Oracle Application Express.

Spreadsheet Handling

You can use the Data Workshop to quickly upload spreadsheet data directly into the database. Alternatively, you can use the Create Application from Spreadsheet Wizard which both loads the data and produces an application to maintain it into the future. In either method, you can store the data in a new database table or add it to an existing database table. These handy tools enable you to go from spreadsheet to a shared application in just a few clicks.

Websheet applications are designed to enable business users, not developers, to define and manage their own data. Users can create a data grid from a spreadsheet or simply define their own data grid specifying column names and data types. Websheets manage the definition and storage of the data without requiring users to create database objects.

Cancel
Internal Server Error

500 - Internal Server Error 

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/f?p=4600:8:16825664896272::NO:::
==== Headers in Request ====
accept: */*
user-agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
cookie: ORA_WWV_USER_63113586886954=ORA_WWV-qFAla7yNSDSOevt4xLBUZ9YN
accept-encoding: gzip, br, zstd, deflate
referer: http://reconquistatramites.gov.ar:9095/apex/f?p=4600%3A8%3A1672067577038%3A%3ANO%3A%3A%3A
host: reconquistatramites.gov.ar:9095
==== Cookies in Request ====
ORA_WWV_USER_63113586886954 =  ORA_WWV-qFAla7yNSDSOevt4xLBUZ9YN
request parameter: p=4600:8:16825664896272::NO:::
isValidRequest(), procedure name: 
Validating: f
*** Total number of arguments: 15
SID: 469
Parse: 0 ms
-----
begin 
 f(p=>?);
commit;
  end;
*** Total number of arguments: 15
{p=4600:8:16825664896272::NO:::}
p=4600:8:16825664896272::NO:::
p= 4600:8:16825664896272::NO:::
Exec: 122 ms
Got results length: 9327
==== Headers from Results ====
Setting Content-Type (Content-type): text/html; charset=utf-8
Adding X-Frame-Options: DENY
Adding X-DB-Content-length: 9327
Processed PL/SQL Gateway request


WebException [statusCode=500]
	at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)
	at oracle.dbtools.rt.web.WebException.internalError(WebException.java:262)
	at oracle.dbtools.rt.web.WebErrorResponse.internalError(WebErrorResponse.java:101)
	at oracle.dbtools.rt.web.WebErrorResponse.error(WebErrorResponse.java:75)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.util.ConcurrentModificationException
	at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372)
	at java.util.AbstractList$ListItr.set(AbstractList.java:409)
	at java.util.Collections.sort(Collections.java:121)
	at oracle.dbtools.apex.statistics.Statistics.toString(Statistics.java:227)
	at oracle.dbtools.apex.statistics.Statistics.print(Statistics.java:174)
	at oracle.dbtools.apex.statistics.Statistics.finishRequest(Statistics.java:141)
	at oracle.dbtools.apex.ModApexContext.close(ModApexContext.java:324)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:155)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:149)
	at oracle.dbtools.common.util.Closeables$BaseCloser.close(Closeables.java:239)
	at oracle.dbtools.common.util.Closeables.close(Closeables.java:97)
	at oracle.dbtools.apex.ModApex.close(ModApex.java:176)
	at oracle.dbtools.apex.ModApex.doGet(ModApex.java:101)
	at oracle.dbtools.apex.ModApex.service(ModApex.java:301)
	at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:347)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)
	... 13 more