Home » Developer & Programmer » JDeveloper, Java & XML » How to access Varrays from Java using JDBC
How to access Varrays from Java using JDBC [message #91062] Sun, 17 March 2002 07:44 Go to next message
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
Re: How to access Varrays from Java using JDBC [message #91143 is a reply to message #91062] Fri, 03 May 2002 23:42 Go to previous message
Sameer Menon
Messages: 1
Registered: May 2002
Junior Member
Even I have a similar application to be implemented.
One has to use the JDBC API that comes along with the 8i .

Try the example given in this link
http://www.db.ucsd.edu/CSE132B-S01/jdbc_doc/samapp3.htm#1004567
Previous Topic: Re: JDBC Connection failed
Next Topic: Yip I have the same problem
Goto Forum:
  


Current Time: Thu Aug 05 00:24:25 CDT 2021