B Oracle Application Express Limits

Learn about limits associated with Oracle Application Express components.

The Oracle Application Express development environment has no limits as to the number of workspaces or number of users that can exist in a given workspace.

• Component Limits
  

B.1 Component Limits

The following table describes limits associated with Oracle Application Express components, such as interactive reports, classic reports, forms, and tabular forms.

Table B-1 Component Limits

Component	Limits	To Learn More...
Data loading	When loading data, the maximum number of columns is 45.	"Managing Applications with Legacy Data Loading Capability"
Export of interactive report and classic report using external print server	If using an external print server, there is a 32k limitation on the generated report template header sub-template. Also, depending on the column alias lengths, approximately 26 columns (or less) are supported.	"Exporting an Application and Application Components"
Forms	32767 bytes for a text area or rich text editor item. Two columns for primary key (when using built in DML processes). For users with more than two primary key columns defined, you can also specify a ROWID.	"Developing Forms"
Interactive reports	999 rows per column heading filter (if no custom LOV is specified in the column attributes). A chart within an interactive report can render up to 10000 data points.	"Developing Reports"
Item names	Item names should not exceed 30 characters. Items longer than 30 characters cannot be referenced using bind variable syntax.	"Referencing Session State Using Bind Variable Syntax" "About Item Naming Conventions"
Tabular Forms	One wizard-generated tabular form per page (using built-in DML). 50 editable tabular form columns (apex_application.g_f01-apex_application.g_f50), generated with apex_item or the built-in tabular form display types.	"Managing Legacy Tabular Forms"
Validations	Text entered for validations may not exceed 3,950 characters.	"Understanding Validations"