Oracle and SSP
Oracle and SSP
zajc
Posts: 67Questions: 10Answers: 2
Can you fix SSP not working in Oracle? I found out the main problem is rownum
. On 1st page everything is OK, because in the where condition is where rownum < x
. The problem is when you construct where rownum between x and y
. The problem is that Oracle understand only where rownum is less then...
, for example where rownum < 100
. There are several approaches how to avoid this limitation.
Replies
This is with the Editor PHP libraries I presume? What version of Oracle are you using please?
Allan