var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Length limit of varchar2 datatype
What is the lenght limit of varchar2 data type while used in Oracle store procedure?
Maybe you will be surprised, there are many official documentation books about Oracle, available e.g. online on http://tahiti.oracle.com/. PL/SQL User's Guide and Reference book contains this information (you really should look into it if you plan using PL/SQL).
For 10gR2 it is stated here: http://download.oracle.com/docs/cd/B....htm#sthref733
The VARCHAR2 datatype takes a required parameter that specifies a maximum size up to 32767 bytes.
Just to be precise (and as quoted by flyboy): it's bytes not characters.
Originally Posted by andrewst
What to do if we want more then these bytes
Use the data type which supports it. If you read the link I posted (or the same part for your Oracle version), you should get acknowledged about CLOB data type.
Originally Posted by sayyed_kamran