1 Reply Latest reply: Aug 23, 2012 12:52 PM by cj RSS

    oracle and php 5.4 doesn't work

    957615
      Description:
      ------------
      I was using php 5.3 with oracle client 11g and everything works fine. I have a wep app already in production with php5.3. I tried upgrade to php5.4, so I install in another folder XAMPP 1.8 who uses php 5.4. I tried everything to make oracle works, but I cannot connect in the database. Its really strange because in the same machine with the same remote database php 5.3 works just fine.
      I am using in php 5.3 o php_oci8.dll with oracle client 11g
      and with php5.4 I tried use php_oci8.dll. The error is:
      ORA-12154: TNS:could not resolve the connect identifier specified
      after I tried php_oci8_11g.dll and the the error is:
      ORA-24315: illegal attribute type

      I on a Windows Vista 64bit Machine,
      Both php are 32bis,
      oracle client is 32bits
      The database is in another machine.

      I think that everything that you need to simulate the problem is install XAMPP 1.8, enable php_oci8.dll and try run the test script.


      Test script:
      ---------------
      print_r(get_loaded_extensions());
      print_r(get_extension_funcs('oci8'));
      echo system('env');
      echo "Client Version: " . oci_client_version();
      print_r(oci_pconnect(DBUSER, DBPASSWORD, DBTNS));

      print_r(oci_error());
      die();



      Expected result:
      ----------------
      I was expecting that the oci_pconnect works, because the same script with php 5.3, works.

      Actual result:
      --------------
      Array
      (
      [0] => Core
      [1] => bcmath
      [2] => calendar
      [3] => com_dotnet
      [4] => ctype
      [5] => date
      [6] => ereg
      [7] => filter
      [8] => ftp
      [9] => hash
      [10] => iconv
      [11] => json
      [12] => mcrypt
      [13] => SPL
      [14] => odbc
      [15] => pcre
      [16] => Reflection
      [17] => session
      [18] => standard
      [19] => mysqlnd
      [20] => tokenizer
      [21] => zip
      [22] => zlib
      [23] => libxml
      [24] => dom
      [25] => PDO
      [26] => bz2
      [27] => SimpleXML
      [28] => wddx
      [29] => xml
      [30] => xmlreader
      [31] => xmlwriter
      [32] => apache2handler
      [33] => Phar
      [34] => mbstring
      [35] => exif
      [36] => gd
      [37] => gettext
      [38] => mysql
      [39] => mysqli
      [40] => oci8
      [41] => pdo_mysql
      [42] => pdo_sqlite
      [43] => soap
      [44] => sockets
      [45] => sqlite3
      [46] => xmlrpc
      [47] => xsl
      [48] => mhash
      )
      Array
      (
      [0] => oci_define_by_name
      [1] => oci_bind_by_name
      [2] => oci_bind_array_by_name
      [3] => oci_field_is_null
      [4] => oci_field_name
      [5] => oci_field_size
      [6] => oci_field_scale
      [7] => oci_field_precision
      [8] => oci_field_type
      [9] => oci_field_type_raw
      [10] => oci_execute
      [11] => oci_cancel
      [12] => oci_fetch
      [13] => oci_fetch_object
      [14] => oci_fetch_row
      [15] => oci_fetch_assoc
      [16] => oci_fetch_array
      [17] => ocifetchinto
      [18] => oci_fetch_all
      [19] => oci_free_statement
      [20] => oci_internal_debug
      [21] => oci_num_fields
      [22] => oci_parse
      [23] => oci_new_cursor
      [24] => oci_result
      [25] => oci_client_version
      [26] => oci_server_version
      [27] => oci_statement_type
      [28] => oci_num_rows
      [29] => oci_close
      [30] => oci_connect
      [31] => oci_new_connect
      [32] => oci_pconnect
      [33] => oci_error
      [34] => oci_free_descriptor
      [35] => oci_lob_save
      [36] => oci_lob_import
      [37] => oci_lob_size
      [38] => oci_lob_load
      [39] => oci_lob_read
      [40] => oci_lob_eof
      [41] => oci_lob_tell
      [42] => oci_lob_truncate
      [43] => oci_lob_erase
      [44] => oci_lob_flush
      [45] => ocisetbufferinglob
      [46] => ocigetbufferinglob
      [47] => oci_lob_is_equal
      [48] => oci_lob_rewind
      [49] => oci_lob_write
      [50] => oci_lob_append
      [51] => oci_lob_copy
      [52] => oci_lob_export
      [53] => oci_lob_seek
      [54] => oci_commit
      [55] => oci_rollback
      [56] => oci_new_descriptor
      [57] => oci_set_prefetch
      [58] => oci_set_client_identifier
      [59] => oci_set_edition
      [60] => oci_set_module_name
      [61] => oci_set_action
      [62] => oci_set_client_info
      [63] => oci_password_change
      [64] => oci_free_collection
      [65] => oci_collection_append
      [66] => oci_collection_element_get
      [67] => oci_collection_element_assign
      [68] => oci_collection_assign
      [69] => oci_collection_size
      [70] => oci_collection_max
      [71] => oci_collection_trim
      [72] => oci_new_collection
      [73] => oci_free_cursor
      [74] => ocifreecursor
      [75] => ocibindbyname
      [76] => ocidefinebyname
      [77] => ocicolumnisnull
      [78] => ocicolumnname
      [79] => ocicolumnsize
      [80] => ocicolumnscale
      [81] => ocicolumnprecision
      [82] => ocicolumntype
      [83] => ocicolumntyperaw
      [84] => ociexecute
      [85] => ocicancel
      [86] => ocifetch
      [87] => ocifetchstatement
      [88] => ocifreestatement
      [89] => ociinternaldebug
      [90] => ocinumcols
      [91] => ociparse
      [92] => ocinewcursor
      [93] => ociresult
      [94] => ociserverversion
      [95] => ocistatementtype
      [96] => ocirowcount
      [97] => ocilogoff
      [98] => ocilogon
      [99] => ocinlogon
      [100] => ociplogon
      [101] => ocierror
      [102] => ocifreedesc
      [103] => ocisavelob
      [104] => ocisavelobfile
      [105] => ociwritelobtofile
      [106] => ociloadlob
      [107] => ocicommit
      [108] => ocirollback
      [109] => ocinewdescriptor
      [110] => ocisetprefetch
      [111] => ocipasswordchange
      [112] => ocifreecollection
      [113] => ocinewcollection
      [114] => ocicollappend
      [115] => ocicollgetelem
      [116] => ocicollassignelem
      [117] => ocicollsize
      [118] => ocicollmax
      [119] => ocicolltrim
      )
      Client Version: 11.1.0.6.0
      <b>Warning</b>: oci_pconnect(): in <b>C:\xampp18\htdocs\config\aguaCheiro.php</b> on line <b>25</b>
      Array
      (
       => 24315
          [message] => ORA-24315: invalid atribute type
          [offset] => 0
          [sqltext] =>
      )