I'm running into a problem with getting Oracle to work with PHP.
Specific information on my installation is below. All appearances show
that oci support configured, built and installed fine in my PHP build.
However, I try to access any oci function and I get something like this:
Fatal error: Call to undefined function: oci_close() in
/opt/ct/htdocs/costtool/access.php on line 3
Can anybody tell me what might be the problem ? I see nothing in the
documentation that would indicate I'm missing anything, yet it still
won't work.
Please respond directly.
Thanks,
John
I've just built php on Solaris 9 with the following options:
ORACLE_HOME=/export/home/oracle/OraHome1/lib;export ORACLE_HOMECC=gcc
CXX=g++
LDFLAGS="-L/opt/ct/lib -R/opt/ct/lib -L${ORACLE_HOME} -R${ORACLE_HOME}"
CPPFLAGS="-I/opt/ct/include -I${ORACLE_HOME}/rdbms/demo
-I${ORACLE_HOME}/rdbms/p
ublic"
LD_LIBRARY_PATH=/opt/ct/lib:${ORACLE_HOME}/lib
export CC CXX LDFLAGS CPPFLAGS LD_LIBRARY_PATH
../configure --prefix=/opt/ct --with-openssl=/opt/ct --with-zlib
--with-db4=/opt/ct --with-ldap=/opt/ct --with-mysql=/opt/ct
--with-oci8=/export/home/oracle/OraHome1 --with-exec-dir=/opt/ct/bin
--with-apxs2=/opt/ct/bin/apxs
The Oracle Client Interface stuff looks like it build fine:
..
..
checking for Oracle (OCI8) support using ORACLE_HOME installation... yes
checking Oracle Install Directory... /export/home/oracle/OraHome1
checking Oracle version... 8.1
checking for OCILobIsTemporary in -lclntsh... yes
checking for OCICollAssign in -lclntsh... yes
..
..
..
make ran ok. make install ran ok. I do the following:
ldd php | grep oracle
libclntsh.so.8.0 => /export/home/oracle/OraHome1/lib/libclntsh.so.8.0
libjava.so =>
/export/home/oracle/OraHome1/JRE/lib/sparc/native_threads/libjava.so
libwtc8.so => /export/home/oracle/OraHome1/lib/libwtc8.so
nm php | grep oci
[883] | 296092| 44|FUNC |LOCL |0 |9 |_oci_bind_hash_dtor
[899] | 294504| 196|FUNC |LOCL |0 |9 |_oci_bind_post_exec
[902] | 294492| 12|FUNC |LOCL |0 |9 |_oci_bind_pre_exec
[888] | 302592| 436|FUNC |LOCL |0 |9 |_oci_close_server
[891] | 301732| 700|FUNC |LOCL |0 |9 |_oci_close_session
[772] | 296540| 84|FUNC |LOCL |0 |9 |_oci_coll_list_dtor
[893] | 295880| 212|FUNC |LOCL |0 |9 |_oci_column_hash_dtor
[904] | 299136| 28|FUNC |LOCL |0 |9 |_oci_column_pre_fetch
[631] | 295432| 428|FUNC |LOCL |0 |9 |_oci_conn_list_dtor
[898] | 296136| 80|FUNC |LOCL |0 |9 |_oci_define_hash_dtor
[884] | 296624| 164|FUNC |LOCL |0 |9
|_oci_descriptor_list_dtor
[881] | 298300| 216|FUNC |LOCL |0 |9 |_oci_get_ocicoll
[890] | 298516| 156|FUNC |LOCL |0 |9 |_oci_get_ocidesc
[895] | 299872| 456|FUNC |LOCL |0 |9 |_oci_make_zval
[619] | 303048| 44|FUNC |LOCL |0 |9 |_oci_server_list_dtor
[661] | 302496| 96|FUNC |LOCL |0 |9 |_oci_session_cleanup
[875] | 302452| 44|FUNC |LOCL |0 |9
|_oci_session_list_dtor
[900] | 296788| 488|FUNC |LOCL |0 |9 |_oci_stmt_list_dtor
[616] | 0| 0|FILE |LOCL |0 |ABS |oci8.c
[6170] | 1566844| 72|OBJT |GLOB |0 |22 |oci8_module_entry
[878] | 301252| 244|FUNC |LOCL |0 |9 |oci_bind_in_callback
[665] | 301496| 236|FUNC |LOCL |0 |9 |oci_bind_out_callback
[663] | 1591984| 4|OBJT |LOCL |0 |24
|oci_coll_class_entry_ptr
[620] | 295308| 124|FUNC |LOCL |0 |9 |oci_debug
[892] | 303092| 4232|FUNC |LOCL |0 |9 |oci_do_connect
[621] | 294872| 436|FUNC |LOCL |0 |9 |oci_error
[885] | 300328| 924|FUNC |LOCL |0 |9 |oci_fetch
[877] | 297560| 408|FUNC |LOCL |0 |9 |oci_get_col
[688] | 297276| 100|FUNC |LOCL |0 |9 |oci_get_conn
[906] | 297480| 80|FUNC |LOCL |0 |9 |oci_get_desc
[889] | 297376| 104|FUNC |LOCL |0 |9 |oci_get_stmt
[6017] | 1598992| 32|OBJT |GLOB |0 |24 |oci_globals
[617] | 294700| 172|FUNC |LOCL |0 |9 |oci_handle_error
[660] | 299164| 708|FUNC |LOCL |0 |9 |oci_loadlob
[901] | 1591980| 4|OBJT |LOCL |0 |24
|oci_lob_class_entry_ptr
[894] | 297968| 332|FUNC |LOCL |0 |9 |oci_new_desc
[896] | 298672| 464|FUNC |LOCL |0 |9 |oci_parse
[880] | 1567504| 108|OBJT |LOCL |0 |22
|php_oci_coll_class_functi
ons
[882] | 295860| 20|FUNC |LOCL |0 |9
|php_oci_free_conn_list
[664] | 1566916| 588|OBJT |LOCL |0 |22 |php_oci_functions
[662] | 1567612| 96|OBJT |LOCL |0 |22
|php_oci_lob_class_functio
ns
[5662] | 307980| 1748|FUNC |GLOB |0 |9 |zif_ocibindbyname
[4578] | 319540| 144|FUNC |GLOB |0 |9 |zif_ocicancel
[6365] | 313980| 412|FUNC |GLOB |0 |9 |zif_ocicloselob
[5549] | 326128| 1456|FUNC |GLOB |0 |9 |zif_ocicollappend
[5244] | 328444| 304|FUNC |GLOB |0 |9 |zif_ocicollassign
[6533] | 328748| 1684|FUNC |GLOB |0 |9 |zif_ocicollassignele
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
