Context,Limit Applied To,Value,Notes
"SQL*Plus, JDBC, ODBC, .NET, etc.",One complete SQL or PL/SQL statement sent from the client,"32,767 bytes","Hard limit in older Oracle client libraries (OCI7, OCI8)"
VARCHAR2 in SQL,Maximum size you can declare in SQL,"32,767 bytes (in SQL scope)",Because of the above client limit
PL/SQL VARCHAR2,Maximum size in PL/SQL code,"32,767 bytes",Same root cause
Extended data types disabled,"VARCHAR2, NVARCHAR2, RAW in table columns","4,000 bytes",Old pre-12c limit
Extended data types enabled,"VARCHAR2, NVARCHAR2, RAW in table columns","32,767 bytes",Requires MAX_STRING_SIZE = EXTENDED (Oracle 12c+)
Query Filter
Posted on
limit
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)