next record using OCI

[Anon]

Does anyone have an example of how to move to the next record in Oracle using OCI?

thanks
abe

[Anon]

I found a very nasty way of doing this because at the time there didn't look to be any easier way. Things are just so much easier with MySQL 😉

I basically loaded the result set into an array and kept track of the array index when I went to another page - and did it again...

Like I said, this is a really slow and nasty way of doing this because you have to load the array up, which can take a long time depending on how many results you get.

Anyone out there have a better idea?

[Anon]

I thought I might have to do that. Do you know of a way to move to a specific row in a record?

[Anon]

I'm not really following you, could you be a little more specific?

[Anon]

I recently wrote a port of our database abstraction layer to oracle.

You can checkout our CVS code at:

http://sourceforge.net/docman/display_doc.php?docid=751&group_id=1

And the files in question are at:

mysql version:
/alexandria/www/include/database.php

and the OCI version is at:
/alexandria/www/include/database-oci8.php

Let me know what you think.

[Anon]

I don't see any seek functions in oracle at all. I guess you need to use a cursor somehow to do your seeks. It's definitely not as easy as mysql.

Please post a followup when you get it figured out - I think the oracle stuff can help a lot of people.

[Anon]

Let's say I have a SELECT statement that returns 10 records and I want to move to the 8 record and display results using "OCIResult". How would I move to that specific record.

Currently I'm running my results through a while loop and I want to return to the first record at the end of the loop.

If anyone has a solution I would love to hear it.

thanks
abe

[Anon]

Does this help? This is what I'm currently doing...

Example table called 'users':

1,dennis,craig,[e-mail]
2,clown,bozo,[e-mail]
3,clinton,bill,[e-mail]

$query = OCIParse($yourconnection,
"SELECT * FROM users"
);

OCIExecute($query)

$i = 1;

while (OCIFetchInto($query, $result_array) ) {
$result[$i] = $result_array;
$i++;
}

$result[1][1] should be 'dennis'
$result[3][3] should be '[e-mail]'

You get the picture, not sure if this is what you wanted and there's probably a better way to do it.

Dennis