-
Store more than 4000 characters in a datatype
In a procedure i am trying to store character data more than 4000 characters. Since, varchar2 doesnt allow more than 4000 bytes. What can be other probable solutions. Tried using CLOB but could get the desired results.
Regards,
Surajit K Mitra
-
In a procedure, a varchar2 can have a bit over 32000 characters.
As a database column, you can use either a CLOB (normally best), LONG (there's various restrictions on using LONGs and I don't know of any good reasons for using them), or multiple VARCHAR2 columns [eg if you know it will never be more than 8000 characters, you can use two varchar2(4000)].
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|