note 21000 added to ref.oci8

Debian / Apache / PHP oci8 / Oracle I just wanna tell my experience compiling the oci8 support from php debian sources. It gave me a lot of headache and I think it might be useful for others who use debian. This is for debian woody (3.0), php 4.1.2, apache 1.3.24, oracle 8.1.7 (of course, it might be useful for other versions) The Debian packages have not oci8 compiled in, so you must get the sources. Then I edited the debian/rules file and added the following: on top: ORACLE_HOME=my_ora_home_here export ORACLE_HOME LD_LIBRARY_PATH=/lib:/usr/lib:/$ORACLE_HOME/lib export LD_LIBRARY_PATH to the COMMON_CONFIG variable: --with-oci8=shared,${ORACLE_HOME} to the modules variable, just bellow the above: oci8 (like ... mhash, mysql, oci8, odbc ...) The "shared" keyword was the key for me. Before using it I was getting "ld: cannot find -lclntsh" on the compile time. This way the compiling with dpkg-buildpackage went fine. If oci8.so does not show up in the modules directory after install, look php-source-path/apache-build/ext/oci8/.libs - it's there. If this still fails, look also to the oracle-stubs problem. Oracle is compiled against glibc 2.1 and woody comes with 2.2. But oracle gives some stubs libs for work-around the problem. I don't know if this is necessary for the client libs, but I suggest trying. Look at Oracle docs. Now things goes terribly fine here. []'s Diego Morales, Porto Alegre - Brazil. -- http://www.php.net/manual/en/ref.oci8.php http://master.php.net/manage/user-notes.php?action=edit+21000 http://master.php.net/manage/user-notes.php?action=delete+21000 http://master.php.net/manage/user-notes.php?action=reject+21000