Application Express

PreviousNext

Object Browser

The Object Browser is the window into your database. Simply select the desired object type and then select an object. All the details of that object are then available to you for browsing and editing. Object Browser enables you to:

  • Browse objects by object type and schema
  • Create objects using wizards
  • View SQL create syntax
  • View subordinate objects
  • Modify existing objects
  • Report dependencies
  • View data for tables and views

SQL

SQL Commands is used to process any SQL command or execute any block of PL/SQL code. Capabilities include:

  • Running SQL commands or PL/SQL blocks
  • Query results are displayed in a tabular result set
  • Viewing explain plans for queries and DML operations
  • Describing database objects
  • Saving SQL queries for later use
  • Accessing command history

Scripts can contains one or more SQL statements. Scripts are run in the background, and you can monitor the progress and view related reports. SQL Script results are archived for reference. Scripts can call other scripts, so all statements need not be co-located in a single script. Capabilities include:

  • Uploading and downloading SQL Scripts
  • Running Scripts in the background
  • Viewing script result logs

RESTful Services

RESTful Services allow for the declarative specification of RESTful services mapped to SQL and PL/SQL.

  • Expose stored procedures as RESTful web services
  • Declaratively return SQL query results as JSON
  • Return query results as XML
  • Map URI's to bind variables
  • Supports get and post methods

Query Builder

The Query Builder enables you to build queries graphically by dropping tables and views into a panel. Joins can be defined by dragging and dropping corresponding column names. The query can be tested and then saved for later use. Capabilities include:

  • Dragging and dropping tables and views to be queried
  • Graphically joining tables
  • Running query and view results
  • Viewing SQL query syntax
  • Automatically discovering joins from the data dictionary

User Interface Defaults

To improve the productivity of application development, User Interface Defaults, a feature of SQL Workshop Utilities, supports the specification of friendly names and other attributes. This enables the create wizards to default the friendly name rather than the actual name (for example, specifying Employee Name for EMPNO). You can define labels, format masks, help text and other attributes.

Additional features include:

  • Synchronizing pages with User Interface Default managed labels and format masks
  • Managing User Interface Defaults by table and column or by attribute name
  • Populating User Interface Defaults from completed form or report pages

Utilities

There are many other utilities in addition to User Interface Defaults. These include:

  • Data Workshop - Load and unload data in text, XML and spreadsheet formats
  • Object Reports - View reports of all objects accessible to your Workspace
  • Generate DDL - Create DDL for all or selected objects within your schemas
  • Recycle Bin - View and recover dropped objects
  • Schema Comparison - View the differences between two schemas accessible to your workspace
  • Database Monitor - Monitor the activity affecting your workspace such as sessions and Long Operations (these require a database administrator login)
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:12:17479635983401::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-jaExlcMd4B4S1gv91YhhVjoQ
accept-encoding: gzip, br, zstd, deflate
referer: http://reconquistatramites.gov.ar:9095/apex/f?p=4600%3A12%3A19805193335590%3A%3ANO%3A%3A%3A
host: reconquistatramites.gov.ar:9095
==== Cookies in Request ====
ORA_WWV_USER_63113586886954 =  ORA_WWV-jaExlcMd4B4S1gv91YhhVjoQ
request parameter: p=4600:12:17479635983401::NO:::
isValidRequest(), procedure name: 
Validating: f
*** Total number of arguments: 15
SID: 730
Parse: 0 ms
-----
begin 
 f(p=>?);
commit;
  end;
*** Total number of arguments: 15
{p=4600:12:17479635983401::NO:::}
p=4600:12:17479635983401::NO:::
p= 4600:12:17479635983401::NO:::
Exec: 88 ms
Got results length: 12619
==== Headers from Results ====
Setting Content-Type (Content-type): text/html; charset=utf-8
Adding X-Frame-Options: DENY
Adding X-DB-Content-length: 12619
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$Itr.next(AbstractList.java:343)
	at java.util.Collections.sort(Collections.java:120)
	at oracle.dbtools.apex.statistics.Statistics.toString(Statistics.java:226)
	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