If you don't see --enable-sigchild in phpinfo() then :
(a) you are not running the version you compiled
(b) your config script had something wrong.
Baseline: if you don't see it, it's not there.
You have to recompile.
-Stathis.
Bob Kakalec wrote:
>
> When I execute an sql statement against my Oracle database from PHP, I
> create an oracle <zombie> process. This eventually hits a "number of
> zombie process" limit and prevents my page from executing.
>
> The queries work properly (except for the zombie problem).
>
> Here is a sample that creates the zombie process:
>
> putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6");
> putenv("ORACLE_SID=dbase_name");
> putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin"); //
> thought this might help the zombie problem
>
> $conn=OCILogon("get_rid_of" , "zombie");
>
> $sql_get_info="SELECT OppID, OppTitle FROM TEST WHERE OppID=4";
> $stmt = OCIParse($conn,$sql_get_info);
>
> OCIExecute($stmt);
>
> OCIFetch($stmt));
>
> $valid_opp_id = OCIResult($stmt, "OPPID");
> $valid_opp_title = OCIResult($stmt, "OPPTITLE");
>
> OCIFreeStatement($stmt);
>
> ///// using a separate query to get the clob......
> $clob_field="OPPTEXT"; // this field in UPPPER CASE
> $sql="SELECT $clob_field from TEST WHERE OppID=$oid";
>
> $stmt = OCIParse($conn, $sql);
> $clob_text = OCINewDescriptor($conn,OCI_D_LOB);
> OCIDefineByName($stmt, $clob_field, &$clob_text);
> OCIExecute($stmt);
> OCIFetch($stmt);
> $valid_text=$clob_text->load();
>
> $clob_text->free();
> OCIFreeStatement($stmt);
>
> Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) :
>
> ./configure --with-apxs=/usr/local/apache/bin/apxs
> --with-config-file-path=/etc/httpd
> --with-oracle=/ora8/m01/app/oracle/product/8.1.6
>
> I also added OCI8 support via..
> --with-oci8=/ora8/m01/app/oracle/product/8.1.6 ... phpinfo(); states
> oci8 support is "enabled".
>
> I did --enable-sigchild but I don't see it showing in the phpinfo();
> ???
>
> I am using: Oracle 8.1.6, Apache 1.3.12 , RedHat 6.0 - all on one
> server.
>
> Any ideas on what I might be doing wrong? Am I missing something? Any
> help would be greatly appreciated.
>
> Thanks,
>
> Bob
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]