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