changing column type from Varchar2 to BLOB

Hi this is not exactly related to JDBC...which would be coming later...i have a table with a certain column of type Varchar2 ...i have to change the type of this column to BLOB...and also preserve the data in the table.. .Please help.

[255 byte] By [@developer@a] at [2007-11-27 1:34:47]

«« ulimit
»» Columns in JTable, Help!

# 1

what is the use of storing string data as blob?anyways i dont think its possible.

agwl_manisha at 2007-7-12 0:42:28 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

The Varchar datatype can store at the most 2000 bytes while the BLOB has a much larger size.thats the point.!

@developer@a at 2007-7-12 0:42:28 >

# 3

Store as TEXT instead.

BalusCa at 2007-7-12 0:42:28 >

# 4

Hi well actually the input can be anything....it could even be an XML file..with a huge size...thats why i have to change the datatype to BLOB.Please let me know if there z a way!!

@developer@a at 2007-7-12 0:42:28 >

# 5

hi...

when i am inserting value into the blob...for which like i have written a function...i have to insert it separately for the blob field and separately for the rest of the fields..

when i insert it for the blob field i am getting the Oracle exception -

Exception Message - ORA-22920: row containing the LOB value is not locked

java.sql.SQLException: ORA-22920: row containing the LOB value is not locked

Also is there a way we can insert values into both types of columns at the same time..?

@developer@a at 2007-7-12 0:42:28 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

changing column type from Varchar2 to BLOB

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified