Re: Trouble with rownum in where clause

[gadiy@sun4.miti.com]

     David,
     
     As you may know, ORA-00600 is an error generated by the ORACLE RDBMS. 
     This particular error is an internal ORACLE error.
     
     I would try the following:
     
     1. Run the same query from SQL*Plus or SQL*DBA to see if you get the 
     same error. If you do, pursue with ORACLE support.
     
     2. Try, if possible, to test the same with another database (if there 
     is one) or using another SQL*Net driver.
     
     3. Re-link SQR. This is a process of rebuilding the SQR executable by 
     linking with the ORACLE libraries. It is explain in the installation 
     guide. You can call out Tech Support for help on this one.
     
     In any case, if the problem persists, please open a case with out 
     technical support. You can do so by e-mail to sqrgroup@miti.com
     
     Gadi Yedwab
     MITI


______________________________ Reply Separator _________________________________
Subject: Trouble with rownum in where clause
Author:  usa.net!sqr-users@netcomsv.netcom.com at Internet
Date:    2/27/95 6:33 PM


I am receiving this error when rownum is used in a where clause.
     
(sqr 5528) ORACLE OPEN error 600 in cursor 1:
  ORA-00600:  internal error code, arguments: [12401], [], [], [], [],
     
The version of SQR is 2.5.7 on Oracle V7.0.16 
This error is not listed in the sqr manual.
     
The code goes basically like this:
     
begin-report
  do my_proc
end-report
     
begin-procedure my_proc
begin-select
val1
val2
val3
 from table
where rownum < 10
end-select
end-procedure
     
                            Thanks,
                             David
----------------------------------------------------------------------------
  KINGD@RANDD.ABBOTT.COM                             David R. King    
  Abbott Laboratories Inc.                           Research Computing
     
  Time is a train that changes future to past....
-----------------------------------------------------------------------------