I want to retrieve data from Oracle using JDBC. I am using UNION of two different queries as shown below.


Connection conn = DriverManager.getConnection("jdbcracle:thin:@lakshman:1521:icedb","new_cb","new_cb" );

// Create a statement
Statement stmt = conn.createStatement();

// Query the DB table and get the resultset.
ResultSet rset = stmt.executeQuery("SELECT 'D' Source, Ref.Chrom AS Chr, Ref.Chrom_Start AS ChrStart, Ref.Chrom_End AS ChrEnd, RLink.Gene_Name AS GNam, RLink.Gene_Product AS GProd, RLink.Disease AS Disease, RLink.Ref_mrna_acc AS refacc, SCORE(1) FROM RefGene Ref, RefLink RLink WHERE Ref.Ref_mrna_acc = RLink.Ref_mrna_acc(+) AND Rlik.OMIMID = 109636
UNION
SELECT 'E' Source, Cyt.Chrom AS Chr, Cyt.Chrom_Start AS ChrStart, Cyt.Chrom_End AS ChrEnd, null, null, null, null, null FROM CytoBand Cyt WHERE Cyt.Chrom = '22' AND Cyt.Name = 'q12.2'");

while (rset.next())
{
System.out.println("Source : " + rset.getString("Source"));
System.out.println("Disease : " + rset.getString("Disease"));
}


I am getting the following exception.

java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.j ava) at oracle.jdbc.driver.OracleStatement.doExecuteQuery( OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.executeQuery(Or acleStatement.java) at JDBCSample.main(JDBCSample.java:42) Process Exit...


Can any of u help me at this juncture.

Thanking you in advance,
Saju Joseph