| How to access Varrays from Java using JDBC [message #91062] |
Sun, 17 March 2002 07:44  |
Dimpy
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
Hi,
I have created a table in Oracle which has a field of type VARRAY . Inside my Java program , I am retrieving data from the table and assigning the values to the local variables. For ex..
Suppose I have tags as a column of Varray type in the Table trial and VARRAY is of of number(5)
Now in my Java program
ResultSet rs=statement.executeQuery("select tags from trial");
ARRAY array=((OracleResultSet)rs).getARRAY();
The above line gives an Ora error(SQLException) saying "Table or view does not exist".
However before this line we have already checked the recordset object(rs) and it is not returning null.
So , What is the exact problem.
Thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
