CODEWITHSUNDEEP
javaoracle-databasejdbc
suvojit
suvojit

Reputation: 311

How to store data in ORACLE table column of type SYS.URITYPE

I am trying to store data in a column of Oracle table which is of URITYPE using JDBC. I learned that to supply data to SYS.URITYPE from java, we need to use java.net.URL. I tried exactly same 

pstmt.setURL(4, new java.net.URL("http://google.com"));

but still i keep on getting this error : 

java.sql.SQLException: ORA-00932: inconsistent datatypes: expected SYS.URITYPE got CHAR.

I cant find useful information related to this. I will appreaciate if someone can share infomation on finxing this issue.

Thanks, Suvojit

Upvotes: 2

Views: 753

Answers (0)

Related Questions