RE: DBIx::Recordset and Oracle

>Here's an Oracle-native string SQL example, which may contain errors:

It does contain a small error that can make a huge difference.
In a stateless environment, the correct way to do this is:

select *
from ( select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
where rownum <= MAX_ROWS )
where rnum >= MIN_ROWS
/

It is the only way to paginate a result set in Oracle without doing lots of extra work.
So while I don't use DBIx:Recordset, if it generates anything other than the above sql for you, you are doing lots of unnecessary work and this indepedence thing would once again be biting you because you hadn't ever searched the archives at asktom.oracle.com

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:127412348064



---------------------------------
Start your day with Yahoo! - make it your home page