Justin Bennett wrote:
I'm using PHP 4.3.7 on Redhat 2.1ES against an Oracle 8.1.7Justin, the problem is in persistent connection. If you use new connection, it will work. Persistent connection
database.Using the PHP OCI interface I have an application that opens a
persistent connection and runs a main select to get a list of Items,
then while looping through the results it then runs a function against
these items In which it runs several nested selects (It's a bill of materials explosion), It can be upto 4 or
5 nested selects deep. If I run the selects with an OCI_DEFAULT method
(not commiting on success) the program will run and at certain points
throw a segmentation fault. Usually I don't commit at all when I only
run a select. If however I change the method to commit on success then
it will work fine. Is there a results or transaction buffer maybe I'm
blowing? Does the commit on success free that up?
-- Mladen Gogala Oracle DBA Ext. 121
-- //www.freelists.org/webpage/oracle-l