B Oracle Application Express Limits

This appendix list limits associated with Oracle Application Express development environment and application components.

Topics:

Development Environment Limits

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

Table B-1, "Component Limits" 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

Interactive reports

One interactive report per page

100 columns can be seen using report columns. You can edit additional columns using Tree view or paginating through Report Column Attributes.

999 rows per column heading filter (if no custom LOV is specified in the column attributes)

See Also: "Customizing Interactive Reports" and "Editing Interactive Reports as a Developer". You can edit additional columns using Tree view or paginating through Report Column Attributes.

Classic reports

100 columns can be seen using report columns. You can edit additional columns using Tree view or paginating through Report Column Attributes.

See Also: "Creating a Report Using a Wizard"

Forms

100 enterable items per page

32767 bytes for a text area or rich text editor item

Two columns for primary key (when using built in DML processes)

See Also: "Creating Forms"

Tabular Forms

1 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

See Also: "Creating a Tabular Form"

Item names

Item names should not exceed 30 characters. Items longer than 30 characters cannot be referenced using bind variable syntax. S

See Also: "About Bind Variable Syntax" and "About Item Naming Conventions"

Validations

Text entered for validations may not exceed 3,950 characters.

See Also: "Understanding Validations"