Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

oracle data type length problem

  Asked By: Meenachi    Date: Jan 15    Category: Java    Views: 722

I have a small doubt regarding data insertion in Oracle.
I am trying to insert String data(the length of data if 4500 chars) into oracle
database. I declared the field type as Varchar2(4000) (Oracle is not allowing me
set more than 4000 as length) then which field type I can use to serve my

Please provide me a suitable way to set.



3 Answers Found

Answer #1    Answered By: Funsani Chalthoum     Answered On: Jan 15

blop or something like that .

Answer #2    Answered By: Randall Franklin     Answered On: Jan 15

our team is not accepting to put datatype as bolb/clob.
Is there any performance issue with blob/clob interms of memory or data

can you please send a sample code insert data  into blob/clob data type  using

Answer #3    Answered By: Josie Roberts     Answered On: Jan 15

bolb or raw..............................

Didn't find what you were looking for? Find more on oracle data type length problem Or get search suggestion and latest updates.