[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
- Subject: Trouble with rownum in where clause
- From: KINGD@randb.abbott.com
- Date: Mon, 27 Feb 1995 19:05:16 -0700
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....
-----------------------------------------------------------------------------