| filename length |
system dependent |
| username length |
30 bytes |
| substitution variable name length |
30 bytes |
| substitution variable value length |
240 characters |
| command-line length |
2500 characters |
| LONG |
2,000,000,000 bytes |
| LINESIZE |
system dependent |
| LONGCHUNKSIZE value |
system dependent |
| output line size |
system dependent |
SQL or PL/SQL command-
line size after variable
substitution |
3,000 characters (internal only) |
| number of characters in a COMPUTE command label |
500 characters |
| number of lines per SQL command |
500 (assuming 80 characters per line) |
| maximum PAGESIZE |
50,000 lines |
| total row width |
32,767 characters |
| maximum ARRAYSIZE |
5000 rows |
| maximum number of nested scripts |
20 |
| maximum page number |
99,999 |
| maximum PL/SQL error message size |
2K |
maximum ACCEPT
character string length |
240 Bytes |
| maximum number of substitution variables |
2048 |
