Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> VARCHAR2 greater than 4K?

VARCHAR2 greater than 4K?

From: Hemant Shah <shah_at_typhoon.xnet.com>
Date: Tue, 5 Aug 2003 21:50:27 +0000 (UTC)
Message-ID: <bgp8r3$ag1$1@flood.xnet.com>

Folks,

  I was reading Chapter 4 of Pro*C/C++ Precompiler Programmer's Guide. In it   they say the Oracle Internal Datatype VARCHAR2 must be less than 4000 bytes   (page 4-2), and Oracle external Datatype VARCHAR2 must be less than 65535   bytes (page 4-4).

  How can I define a VARCHAR2 column greater than 4000 bytes?

  When I try to create table using PL/SQL I get following error:

  ORA-00910: specified length too long for its datatype

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.
Received on Tue Aug 05 2003 - 16:50:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US