#42456 [Bgs]: i foud solution, publish it on website

ID: 42456 User updated by: astorozhuk at ukrcard dot com dot ua Reported By: astorozhuk at ukrcard dot com dot ua Status: Bogus Bug Type: OCI8 related Operating System: sles9 PHP Version: 5.2.3 New Comment: google: ociheaders site:oracle.com found http://www.oracle.com/technology/products/ias/ohs/htdocs/php_ohs.htm title of document: Using PHP with Oracle Application Server 10g (! version 10) url of headers found http://www.oracle.com/technology/products/ias/ohs/htdocs/ociheaders.tar wget http://www.oracle.com/technology/products/ias/ohs/htdocs/ociheaders.tar --15:00:49-- http://www.oracle.com/technology/products/ias/ohs/htdocs/ociheaders.tar => `ociheaders.tar' Resolving www.oracle.com... 141.146.8.66 Connecting to www.oracle.com[141.146.8.66]:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1,330,176 [application/x-tar] 100%[==================================================================================>] 1,330,176 13.60K/s ETA 00:00 15:01:52 (22.22 KB/s) - `ociheaders.tar' saved [1330176/1330176] md5sum ociheaders.tar 1d1cc2502e9d1e5bf95c33b5616fb604 ociheaders.tar comparing with headers that was long time ago (few monthes), and installed on system... #OciHeaders # url http://www.oracle.com/technology/products/ias/ohs/htdocs/ociheaders.tar # md5 1d1cc2502e9d1e5bf95c33b5616fb604 ------------------------ conclusions: ociheaders didn't changed last few monthes but on php-5.1.6 they worked and now (php-5.2.3) compilling with them raise error Previous Comments: ------------------------------------------------------------------------ [2007-08-28 11:53:11] jani@php.net Calling people stupid is the best way to report bugs.. Upgrade your oci libs. That's the solution. I copy pasted wrong reply, I was supposed to copy this: [10 May 8:05pm UTC] tony2001@php.net Upgrade to newer Oracle version. ------------------------------------------------------------------------ [2007-08-28 11:28:44] astorozhuk at ukrcard dot com dot ua for education read: http://ua.php.net/oci8 <<< CVII. Oracle Functions Introduction These functions allow you to access Oracle 10, Oracle 9, Oracle 8 and Oracle 7 databases using the Oracle Call Interface (OCI). >>> in our organization oracle versions 9 and 10 and we use oci8 extention to connect to databases ------------------------------------------------------------------------ [2007-08-28 11:24:32] astorozhuk at ukrcard dot com dot ua You must be realy stupid! first read what i wrote about: I'm telling not about oracle8, but about oracle9 and oracle10. extension name is OCI8 , but it used for oracle from 8 to 10 NOT ONLY TO ORACLE 8 (!) ------------------------------------------------------------------------ [2007-08-28 11:14:58] jani@php.net We don't support Oracle 8 anymore. :) ------------------------------------------------------------------------ [2007-08-28 09:45:13] astorozhuk at ukrcard dot com dot ua Description: ------------ 1.look: /usr/local/src/php-5.2.3/ext/oci8/oci8_lob.c:304: error: `OCI_NLS_CHARSET_MAXBYTESZ' undeclared (first use in this function) /usr/local/src/php-5.2.3/ext/oci8/oci8_lob.c:304: error: (Each undeclared identifier is reported only once /usr/local/src/php-5.2.3/ext/oci8/oci8_lob.c:304: error: for each function it appears in.) make: *** [ext/oci8/oci8_lob.lo] Error 1 http://bugs.php.net/bug.php?id=41563&edit=1 [4 Jun 8:36am UTC] tony2001@php.net Sorry, we don't support Oracle 8 anymore. http://bugs.php.net/bug.php?id=41348 [10 May 8:05pm UTC] tony2001@php.net Upgrade to newer Oracle version. 2. description this things happen if compile with OCI8 support you must understand, that it is not ORACLE 8(!) support, it is ORALCE suppurt we have oracle9 or 10 , and OCI8 is standart library (there is no OCI9 OCI10 library, or OCI library) so you replys is stupid 3.solution (solution was took and analysed from http://lists.freebsd.org/pipermail/freebsd-ports-bugs/2007-May/120308.html) solution itself: tar xvfz php-5.2.3.tar.gz cd ext/oci8 EDIT oci8_lob.c, near line 340 add compiler commands to make text: =================================== if (is_clob) { #ifdef OCI_NLS_CHARSET_MAXBYTESZ PHP_OCI_CALL_RETURN(connection->errcode, OCINlsNumericInfoGet, (connection->env, connection->err, &bytes_per_char, OCI_NLS_CHARSET_MAXBYTESZ)); if (connection->errcode != OCI_SUCCESS) { php_oci_error(connection->err, connection->errcode TSRMLS_CC); PHP_OCI_HANDLE_ERROR(connection, connection->errcode); return 1; } #else bytes_per_char = 4; #endif } else { /* BLOBs don't have encoding, so bytes_per_char == 1 */ } =================================== added lines: #ifdef OCI_NLS_CHARSET_MAXBYTESZ #else bytes_per_char = 4; #endif =================================== 4. TODO for you please change your comments to this solution, because i had to use old php version because i dodnt know solution to make it work in new versions and after sawing your replys i was shocked places to change comments http://bugs.php.net/bug.php?id=41563&edit=1 http://bugs.php.net/bug.php?id=41348 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42456&edit=1