I believe I found the problem. right after I posted the original message, I began to work on the chagnes to the page which made me aware of this error in the first place.
Not being the original writer of the page, I looked over the code to get a li'l feel for it and whatnot... I noticed that this page was using the OCIFetchStatement function, whereas I usually just do a while (ocifetchinto... etc. I checked the other page that was also giving me problems, and sure enough, it was using the OCIFetchStatement function. So I rewrote the page to use while (ocifetchinto instead, recompiled PHP4.2.2, tried again, and voila! The page worked now. Not completely satisfied, I looked a little further, and found this in the user contributed notes for OCIFetchStatement: In 4.2.1 additional parameters were added, but are apparently undocumented: OCIFetchStatement($stmt, $results, $return, $skip, $format); $return - the number of rows returned $skip - the number of rows to skip (great for paging through long tables - its very efficient) $format - one of OCI_FETCHSTATEMENT_BY_ROW and OCI_FETCHSTATEMENT_BY_COLUMN And the pages that were having problems were written like this: OCIFetchStatement($stmt, $Result_Array, OCI_ASSOC+OCI_RETURN_NULLS). Looks like the original writer of the page put the OCI_ASSOC+OCI_RETURN_NULLS constants on, despite the fact that I can't find any documentation as to whether these were ever supported by OCIFetchStatement (I use them on ocifetchinto all the time...). So anyway, judging by the user notes about OCIFetchStatement and the new parameters that were added, it looks like that's what was causing my problems... I'm now recompiling 4.2.2 again, w/out the --with-oracle parameter, and then I guess I'm going to have to search thru all our pages to see if there are any other incorrectly written OCIFetchStatement commands like this :) thx! k > -----Original Message----- > From: Jim Thome [mailto:[EMAIL PROTECTED]] > > Recompile without the line: > --with-oracle=/u01/app/oracle/product/8.1.6 > > and see what happens. > > "--with-oracle" is for Oracle-oci7 support. > > Jim > > >>> "Hanser, Kevin" <[EMAIL PROTECTED]> > 08/08/02 14:11 PM >>> > I'm having a really _weird_ problem with PHP 4.2.x and Oracle > 8i (8.1.6). > > I recently decided it was time to update php on our > development server, in > preparation of updating the production server. Currently, > they are both > running 4.0.3pl1. > <snip> > > However, in the course of testing, I noticed that some of our > web pages were > returning incomplete data sets, or no data at all. > -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
