This content has been marked as final. Show 4 replies
In Oracle 8.1.7
VARCHAR2 for PL/SQL
VARCHAR2 datatype takes a required parameter that specifies a maximum size up to 32767 bytes. The syntax follows: VARCHAR2(maximum_size)
how about this
Already answered, max size of VARCHAR2 is 32767 bytes in PL/SQL,
but please don't forget that max size of VARCHAR2 in database is 4000 bytes.
As u wrote, u hv to hold a long line of data from a txt file ?
Then Why u r using a Varchar2 , your line may exceed 32767 boundry in PL/SQL. It's better if u use CLOB which can store upto 4 GB. ( hv to chk whether it works properly with 8.1.7 or not)
Well this suggestion totally depends upon the exact requirements.
Hi all,Message was edited by:
What is the maximum length precision of a VARCHAR2
datatype in Oracle Enterprise Edition 8.1.7 if I
declare a variable in my procedure to hold a long
line of data from a txt file ?
Message was edited by: