Re: Oracle JDBC problem

qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301201527.be52044_at_posting.google.com>...
> SQL: select banner from v$version
> against an Oracle9i db resulted in the following error:
>
> ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [],
> [], [], [], []
>
> I don't have access to Oracle's bug reporting web site, could some one
> kindly post it?
>
> Secondly, is there any alternative to find current server version
> other than the above query? Thanks.

ORA-00600 is an internal error and should be reported to Oracle by you. I just tested this code against a 9i R2 database without any errors... so problem must be somewhere in your code/installation/database.

import java.sql.*;

public class Test {

   public static void main (String args[])

      throws Exception {

      DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());

      String url = "jdbc:oracle:oci8:_at_" + args[0];
      Connection conn =
         DriverManager.getConnection (url, args[1], args[2]);

      Statement stmt = conn.createStatement ();
      ResultSet rset = stmt.executeQuery ("select banner from
v$version");
      while (rset.next())
         System.out.println(rset.getString(1));
      rset.close();    
      stmt.close();    
      conn.close();

C:\JavaDev\test>javac Test.java

C:\JavaDev\test>jview Test.class test920 "sys as sysdba" password Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

Regards
/Rauf Sarwar Received on Tue Jan 21 2003 - 04:35:01 CET