Bug #1277 Updated: OCIDefineByName() causes Apache crash

ID: 1277 User Update by: pumuckel@metropolis.de Status: Open Bug Type: Oracle related Description: OCIDefineByName() causes Apache crash [MODIFIED] Apparently not OCIDefineByName causes the crash, but the OCIFetchRow() later on. My table looks like: CREATE TABLE TESTTABLE ( test1 VARCHAR(150) PRIMARY KEY, test2 VARCHAR(50), test3 VARCHAR(50), title VARCHAR(255), test4 VARCHAR(255), ..... ) TABLESPACE SPACE; The statement is: OCIParse($conn, "SELECT test1,test2,test3,TITLE FROM TESTTABLE WHERE TEST1 LIKE 'A%'"); Then I call following OCI methods: OCIDefineByName($stmt, "TEST1", &$test1); OCIDefineByName($stmt, "TEST2", &$test2); OCIDefineByName($stmt, "TEST3", &$test3); OCIDefineByName($stmt, "TITLE", &$title); while(OCIFetchRow($stmt)) do_something(); If I leave LAST OciDefineByName in my source, php crashes. If I comment out last OCI command, the rest of php3 commands are executed successfully. (I'm running Apache_1.3.4) TRACKED DOWN LATER: I've tracked down the problem with the php binary (without apache) and calling the same query again. This is what gdb tells me: Program received signal SIGSEGV, Segmentation fault. 0x80814dc in oci8_fetch (statement=0x812ca20, nrows=1, func=0x80ba589 "OCIFetch") at functions/oci8.c:1112 1112 pval->value.str.val[ pval->value.str.len ] = 0; (gdb) where #0 0x80814dc in oci8_fetch (statement=0x812ca20, nrows=1, func=0x80ba589 "OCIFetch") at functions/oci8.c:1112 #1 0x8082b42 in php3_oci8_fetch (ht=0x8127fe8, return_value=0x80d07e8, list=0x80f92e0, plist=0x80f92a0) at functions/oci8.c:2108 #2 0x8051d3c in phpparse () at control_structures_inline.h:930 #3 0x805ba18 in php3_parse (yyin=0x81091c0) at main.c:1534 #4 0x805c117 in main (argc=2, argv=0xbffff86c) at main.c:1842 (gdb) print pval $2 = (pval *) 0x812fad8 (gdb) print pval->value.str $3 = {val = 0x80b3920 "", len = 0} (gdb) print column->retcode $4 = 1405 (gdb) print pval->value.str $12 = {val = 0x80b3920 "", len = 0} Full Bug description available at: http://ca.php.net/bugs.php3?id=1277 -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net