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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 14 2005 - 13:32:13 CDT
