This content originally appeared on DEV Community and was authored by Query Filter
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+)
This content originally appeared on DEV Community and was authored by Query Filter
Print
Share
Comment
Cite
Upload
Translate
Updates
There are no updates yet.
Click the Upload button above to add an update.
APA
MLA
Query Filter | Sciencx (2025-11-18T14:06:16+00:00) limit. Retrieved from https://www.scien.cx/2025/11/18/limit/
" » limit." Query Filter | Sciencx - Tuesday November 18, 2025, https://www.scien.cx/2025/11/18/limit/
HARVARDQuery Filter | Sciencx Tuesday November 18, 2025 » limit., viewed ,<https://www.scien.cx/2025/11/18/limit/>
VANCOUVERQuery Filter | Sciencx - » limit. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/11/18/limit/
CHICAGO" » limit." Query Filter | Sciencx - Accessed . https://www.scien.cx/2025/11/18/limit/
IEEE" » limit." Query Filter | Sciencx [Online]. Available: https://www.scien.cx/2025/11/18/limit/. [Accessed: ]
rf:citation » limit | Query Filter | Sciencx | https://www.scien.cx/2025/11/18/limit/ |
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.