A script-enabled browser is required for this page to function properly.

Object Constraints

The following table presents constraints that Oracle Forms has for objects you create and for any other elements that are related to these objects.

Note:

Even though Oracle Forms itself imposes no limits on the number of objects you can create in a form, the amount of memory available can be a limiting factor.

Element

Constraint/Note

blocks per form

no practical limit

canvases/windows

no practical limit

canvas width

no practical limit (24576 points, or 32K pixels)

column name length

30 characters

boilerplate text

no practical limit

database field references

no practical limit

detail blocks per master

no practical limit

global variable length

255 characters

identifiers (block names, field names, parameter list names, etc.)

30 characters

item max length

2000 characters, for CHAR values

items per block

no practical limit

join condition

255 characters

levels of menu nesting

8 - 10, depending on your operating system (When using pulldown menus, it is a good practice to limit menu nesting to four levels.)

list of values

no practical limit

menu items

no practical limit

menus

no practical limit

named visual attributes

255 named visual attributes

PL/SQL strings

no practical limit

WHERE Clause and ORDER BY Clause

total of 32,000 characters

record group character columns

255 characters

record groups

255 columns

substitution parameters

no practical limit

text item range checks per block

no practical limit

triggers

no practical limit

user-defined local variable name length

30 characters



Cursor Constraints