-----Original Message-----
From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 5:33 AM
To: Harris, Jeff
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2
On Tue, Jul 08, 2003 at 05:51:47PM -0500, Harris, Jeff wrote:
>
> We're getting segfaults (11) when we try and execute a simple piece of
> Oracle PHP code. This is a new installation and compilation of Apache2 and
> we're just trying to see what is wrong. This particular code works on all
of
> our Apache 1.3 installations.
>
> Versions: Redhat 8.0, PHP version 4.3.2, Apache version 2.0.46, Oracle
> version 9i 9.2.0.1.0
>
> We've worked through all of the oracle user issues with Apache, made sure
> and set ORACLE_HOME and TNS_ADMIN.
>
> the code we're executing is:
>
> <?php
>
> echo 'here';
> $conn = OCILogon("scott","tiger","db");
> echo 'here2';
>
> $stmt = OCIParse($conn, "select original_system_reference, attribute8 from
> apps.so_headers_interface_all where error_flag = 'Y'");
>
> echo 'here3';
>
> OCIDefineByName($stmt, "ORIGINAL_SYSTEM_REFERENCE", &$order_number);
> OCIDefineByName($stmt, "ATTRIBUTE8", &$attribute8);
>
> OCIExecute($stmt);
> echo 'here4';
>
> while (OCIFetch($stmt)) {
> echo 'here5';
> echo $order_number." ";
> echo ": ".$attribute8."<br>";
> }
>
> echo 'here6';
> echo $order_number." ";
> OCIFreeStatement($stmt);
> OCILogoff($conn);
> echo 'here7';
> ?>
>
>
>
> The server segfaults right after it gets to "here3". If you comment out
> everything after here3, the page works fine. Running the $stmt select
works
> fine if you use sqlplus. I'm not sure why it's dying.
does it also crash when you are not using DefineByName?
re,
tc
Yes, it dies on the OCIExecute.
Jeff
