Apache child process segmentation fault ... when using LOB->load( )
| From: | 陳軍箕) | Date: | Wed, 05 Jul 2000 02:55:40 +0000 |
| Subject: | Apache child process segmentation fault ... when using LOB->load( ) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-852@lists.php.net to get a copy of this message | ||
1 When apache/php execute the following program to the line
2 $field = $field->load();
3 error occurs and the messages in error_log of apache is
4 [Wed Jul 5 10:17:22 2000] [notice] child pid 27719 exit signal
5 Segmentation Fault (11)
If I remark this line, everything will be ok. The Note
column will
displays the word "Object".
What's the problem ??
I am using : Apache 1.3.12/PHP 3.0.16/Oracle 8.1.5
1 <?php
2 $conn = OCILogon("jackie","xxxx","ora");
3 // Show the content of table ex2.
4 $stmt = OCIParse($conn, "select service, note from ex2");
5 OCIExecute($stmt,OCI_DEFAULT);
6 print("<table border=1 width=100% >");
7 print("<tr>");
8 for ( $nrow=1; $nrow<=OCINumCols($stmt); $nrow++)
9 {
10 print("<th>");
11 print(OCIColumnName($stmt, $nrow));
12 }
13 while(OCIFetch($stmt))
14 {
15 print("<tr>");
16 for ( $nrow=1; $nrow<=OCINumCols($stmt); $nrow++ )
17 {
18 print("<td>");
19 $field = OCIResult($stmt, $nrow);
20 if(is_object($field))
21 $field = $field->load();
22 print($field);
23 }
24 }
25 print("</table>");
26 OCIFreeDescriptor($lob);
27 OCIFreeStatement($stmt);
28 OCILogoff($conn);
29 ?>