Edit report at https://bugs.php.net/bug.php?id=62841&edit=1
ID: 62841 Comment by: altieresdelsent at gmail dot com Reported by: altieresdelsent at gmail dot com Summary: ora11g doesn't work Status: Not a bug Type: Bug Package: OCI8 related Operating System: Windows PHP Version: 5.4.6 Block user comment: N Private report: N New Comment: I don't think that is a problem with oracle, because with php5.3 is working just fine. Maybe is a problem with oracle but is related with php5.4, because php5.3 works with the client and php5.4 do not work. anyway thanks for your reply, I followed your advise and register a thread in oracle support for php. the link is: https://forums.oracle.com/forums/thread.jspa?threadID=2430965 Previous Comments: ------------------------------------------------------------------------ [2012-08-23 16:51:33] s...@php.net Please take this issue to a support forum, e.g. https://forums.oracle.com/forums/forum.jspa?forumID=178 ------------------------------------------------------------------------ [2012-08-16 23:00:31] altieresdelsent at gmail dot com 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<br /> <b>Warning</b>: oci_pconnect(): in <b>C:\xampp18\htdocs\config\aguaCheiro.php</b> on line <b>25</b><br /> Array ( [code] => 24315 [message] => ORA-24315: tipo de atributo inv�lido [offset] => 0 [sqltext] => ) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=62841&edit=1
