Previous Next JavaScript must be enabled to correctly display this content

## B Oracle APEX Limits

Learn about limits associated with Oracle APEX components.

- Component Limits
  Learn about limits associated with Oracle APEX components, such as interactive reports, classic reports, forms, and tabular forms.

Related Topics

- Splitting Export Files into Separate SQL Scripts

### B.1 Component Limits

Learn about limits associated with Oracle APEX components, such as interactive reports, classic reports, forms, and tabular forms.

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. | Creating Export Files
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
Native PDF and Excell support in reports | Oracle APEX includes native support for printing basic reports to PDF and Microsoft Excel. If you want full control and advanced layouts for your reports, Oracle recommends using a report server. Limitations for native PDF and Microsoft Excel: A report row in PDF may span multiple lines and may have a single page break. The text is truncated if a row exceeds this limit. The maximum text size of a cell in Microsoft Excel is 32k. The text is truncated If a cell exceeds this limit. | n/a
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

Parent topic: Oracle APEX Limits