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

[Suvojit Chakraborty]

Hi,

I am trying to store data in a column of Oracle table using JDBC. The column is of SYS.URITYPE. 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

Please help to fix this.

Thanks,
Suvojit

[Suvojit Chakraborty]

Figured out the solution with help from another forum. HTTPURIType is to be used in insert statement.

insert into table (uricolumn) values (HTTPURIType('http://www.oracle.com')) where actual URL is query parameter.

[Jeanne Boyarsky]

Thanks for sharing! I had never heard of that type so I learned something new. I gave you a cow for that.