I'm using PHP 4.3.7 on Redhat 2.1ES against an Oracle 8.1.7
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?
Thanks Justin
-- Justin Bennett Network Administrator Dynabrade, Inc. 8989 Sheridan Dr. Clarence, NY 14031
-- //www.freelists.org/webpage/oracle-l
