The following table presents constraints that Oracle Forms has for objects you create and for any other elements that are related to these objects.
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 |