Edit report at https://bugs.php.net/bug.php?id=61142&edit=1
ID: 61142
User updated by: hinaresh2000 at gmail dot com
Reported by: hinaresh2000 at gmail dot com
Summary: error : child pid 16289 exit signal Illegal
instruction (4) - if using SQLT_CHR
-Status: Feedback
+Status: Assigned
Type: Bug
Package: OCI8 related
Operating System: RHEL5.3
PHP Version: 5.3.10
Assigned To: sixd
Block user comment: N
Private report: N
New Comment:
Below is my code snippet which i am using :
$filter_permissions_array = "permissions\n";
$conn=db_connection();
$query = "BEGIN dns_filter_permissions_pkg.insert_customize_brand(:iprange,
:is_apply_to_networks_of_nop, :network_filter_id, :ip_check,
:filter_permissions, :network_cursor, :return_value); END;";
$stmt = oci_parse($conn, $query);
$network_cursor = oci_new_cursor($conn);
oci_bind_by_name($stmt, "iprange", $ip_cidr_range,20);
oci_bind_by_name($stmt, "is_apply_to_networks_of_nop", $set_network_operator,
225);
oci_bind_by_name($stmt, "network_filter_id", $network_filter_id, 10);
oci_bind_by_name($stmt, "ip_check", $ip_check, 10);
oci_bind_array_by_name($stmt, "filter_permissions", $filter_permissions_array,
10000,-1,SQLT_STR);
oci_bind_by_name($stmt, "network_cursor", $network_cursor, -1, OCI_B_CURSOR);
oci_bind_by_name($stmt, "return_value", $return_value, 10);
oci_execute($stmt);
oci_execute($network_cursor);
oci_free_statement($stmt);
oci_close($conn);
The oracle version is 11.2.0.3.0
PHP version is 5.3.9
Thanks,
Naresh
Previous Comments:
------------------------------------------------------------------------
[2012-02-21 20:17:49] [email protected]
I need:
1. A complete PHP test script showing the values (if any) in
$filter_permissions_array.
2. The SQL to create any DB objects used.
3. The versions of the Oracle client libraries and of the database.
Thanks.
------------------------------------------------------------------------
[2012-02-20 11:39:32] hinaresh2000 at gmail dot com
Also i have tested it on another box having php 5.3.9 - (built: Jan 12 2012
15:14:33) then i saw below error in log:
"child pid 7758 exit signal Segmentation fault (11)"
------------------------------------------------------------------------
[2012-02-20 11:26:19] hinaresh2000 at gmail dot com
Description:
------------
---
>From manual page:
>http://www.php.net/function.oci-bind-array-by-name#refsect1-function.oci-bind-array-by-name-returnvalues
---
Hi,
I am testing my application on Amazon Cloud Box where PHP 5.3.9 is installed on
RHEL5.3
Below is my php source code line :
oci_bind_array_by_name($stmt, "filter_permissions", $filter_permissions_array,
10000,-1,SQLT_STR);
here $filter_permissions may or may not contain any value.
The above code line shows error in /var/log/httpd/error_log file that
"child pid 16289 exit signal Illegal instruction (4)"
and browser stops and shows blank page.
The same line is working fine with PHP 5.1.6 and showing results perfectly.
Also if it fails somewhere on any version then i have replaced SQLT_STR with
SQLT_CHR and it works fine. In that case i am not in a position to fix this
issue in 5.3.9.
Is this a PHP issue or the OCI one?
help me resolving this issue.
Thanks in Advance
Naresh K.
Test script:
---------------
Below is my php source code line :
oci_bind_array_by_name($stmt, "filter_permissions", $filter_permissions_array,
10000,-1,SQLT_STR);
here $filter_permissions may or may not contain any value.
The above code line shows error in /var/log/httpd/error_log file that
"child pid 16289 exit signal Illegal instruction (4)"
and browser stops and shows blank page.
Expected result:
----------------
It should run without any error in log and doesn't stop the functionlity of
page at browser.
Actual result:
--------------
Error in log -
"child pid 16289 exit signal Illegal instruction (4)"
and browser stops and shows blank page.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=61142&edit=1
