CREATE TYPE test_obj AS OBJECT(obj_id NUMBER, obj_name VARCHAR2( 30 ));
/

CREATE TABLE test_table(x test_obj);

INSERT INTO test_table VALUES(test_obj( 1 , 'First'));
INSERT INTO test_table VALUES(test_obj( 2 , 'Second'));
COMMIT;

import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;


class testObj {
	public static void main(String[] args) {
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:<DB>", <user>, <pass>);
		} catch (Exception e) {
			System.out.println("Error.");
			System.exit( 0 );
		} //try

		try {
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM test_table");
			while (rs.next()) {
				oracle.sql.STRUCT struct = ((OracleResultSet)rs).getSTRUCT( 1 );
				Object[] attrs = struct.getAttributes();
				for (int i= 0 ; i<attrs.length; i++) {
					System.out.print(attrs[i] + "; ");
				} //for
				System.out.println();
			} // while

			rs.close(); rs = null;
			stmt.close(); stmt = null;
			conn.close(); conn = null;
		} catch (Exception e) {
			e.printStackTrace();
		} //try

	}
};

 1 ; 0x4669727374;
 2 ; 0x5365636F6E64;

java.sql.SQLException: Исключение ввода/вывода: Connection refused
(DESCRIPTION=(TMP=)(VSNNUM= 153093376 )(ERR= 12505 )
(ERROR_STACK=(ERROR=(CODE= 12505 )(EMFI= 4 ))))
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134 )
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 179 )
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 333 )
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java: 404 )
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: 468 )
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java: 314 )
	at java.sql.DriverManager.getConnection(DriverManager.java: 512 )
	at java.sql.DriverManager.getConnection(DriverManager.java: 171 )
...

java.lang.UnsatisfiedLinkError: free_c_state

"jdbc:oracle:oci8:"

<some_path>;.;c:\oracle\...

<some_path>;.c:\oracle\...