Seeking a row using Oracle 8

[netbros]

Does anyone know how to seek to a specific row in the result set using Oracle 8i? Using MS-SQL, the mssql_data_seek () function does the trick, but I can't seem to find the equivalent in the PHP OCI functions.

[bastien]

ROWID

or

ROWIDTOCHAR

But it is hard to say without the code to look at...could you refine the dataset query a little more to return just the one row?

[netbros]

Thanks, mate

I'm not trying to reduce the size of the result set, I just want to jump into the middle of it without having to read each record in sequence.

Any ideas?

[bastien]

😕

are you looking for a random record in the dataset?

[netbros]

I'm looking for a specific record # within the result set - let's say I have 10 results, I want to start reading results from record #5 (or whatever), but don't want to have to read records #1 - 4 first (if possible) as that adds overhead.

[jmcneese]

http://pear.php.net/manual/en/core.db.fetchrow.php