Oracle resource connection reusablility after oci_execute() in PHP

726afc3e-53a3-41cd-be03-ba263bc3990b

I am trying to create a web application which needed to use the same data from the table twice in the application.

1) To create a Table

2) To create a chart

In order to do that I need to use the resource variable after executing twice. But after using OCI_FETCH_ASSOC once, the data is not fetchable next time.

In MYSQL there is an option to seek the resource to point at the beginning of the data. But in oracle i couldnot find that option. Please guide me to get out of this issue.

Christopher Jones-Oracle

PHP OCI8 doesn't support 'Scrollable cursors'.  You will have to cache the results yourself, or re-execute the statement.  If the result set is small you might want to look into Client Result Caching so that the data doesn't need to be returned twice from the database, see p 151 of the free book The Underground PHP and Oracle Manual | Homepage