[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Trouble with rownum in where clause




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....
-----------------------------------------------------------------------------