Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle resource connection reusablility after oci_execute() in PHP

726afc3e-53a3-41cd-be03-ba263bc3990bFeb 8 2017 — edited Feb 8 2017

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2017
Added on Feb 8 2017
1 comment
299 views