| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.misc -> VARCHAR2 greater than 4K?
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
|  |  |