Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2009
    Posts
    22

    Unanswered: Length limit of varchar2 datatype

    What is the lenght limit of varchar2 data type while used in Oracle store procedure?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    32,767 characters

  3. #3
    Join Date
    Mar 2007
    Posts
    623
    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.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by andrewst View Post
    32,767 characters
    Just to be precise (and as quoted by flyboy): it's bytes not characters.

  5. #5
    Join Date
    Jun 2009
    Posts
    22
    What to do if we want more then these bytes

  6. #6
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by sayyed_kamran View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •