Table B-1, "Component Limits" describes limits associated with Oracle Application Express components, such as interactive reports, classic reports, forms, and tabular forms.
Component | Limits |
---|---|
You can edit 100 columns using Component View. You can edit additional columns using Page Designer. 999 rows per column heading filter (if no custom LOV is specified in the column attributes). You can edit additional columns by paginating through Report Column Attributes. Note: Depending on the column alias lengths, approximately 26 columns (or less) are supported. See Also: "Developing Reports" |
|
100 columns can be seen using report columns. You can edit additional columns using Page Designer. See Also: "Developing Reports" |
|
200 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). For users with more than two primary key columns defined, you can also specify a ROWID. See Also: "Developing Forms" |
|
One wizard-generated tabular form per page (using built-in DML). 50 editable tabular form columns ( See Also: "Managing Tabular Forms" |
|
Item names should not exceed 30 characters. Items longer than 30 characters cannot be referenced using bind variable syntax. See Also: "Referencing Session State Using Bind Variable Syntax" and "About Item Naming Conventions" |
|
Text entered for validations may not exceed 3,950 characters. See Also: "Understanding Validations" |
|
When loading data, the maximum number of columns is 45. See Also: "Creating Applications with Data Loading Capability" |