size limit to pass as parameter [message #1601] |
Wed, 15 May 2002 10:32 |
Anthony
Messages: 48 Registered: September 2000
|
Member |
|
|
Hi,
Simple question, (if you know the answer!) I have written a package that has three procedures in it. I send a parameter to one of the procedures, and I would like to know if there is some sort of size limit as to what I can send to it? The parameter is a varchar2 of size upto 5000 characters. I am using oracle 8.1.7
TIA
Anthony
|
|
|
Re: size limit to pass as parameter [message #1636 is a reply to message #1601] |
Thu, 16 May 2002 22:41 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
The Maximum size of a VARCHAR2 is 32767 bytes (in most cases, this is the same as 32767 characters in PL/SQL.
The maximum width of a VARCHAR2 database column is 4000 bytes. Therefore, you cannot insert VARCHAR2 values longer than 4000 bytes into a VARCHAR2 column.
HTH,
MHE
|
|
|