ID: 40186 User updated by: tony at marston-home dot demon dot co dot uk Reported By: tony at marston-home dot demon dot co dot uk -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Windows XP PHP Version: 5.2.0 Assigned To: tony2001 New Comment:
I have tried loading that snapshot, but I am still getting the same error. The call to oci_fetch_array() fails with "ORA-00932: inconsistent datatypes: expected CHAR got ARRAY" Previous Comments: ------------------------------------------------------------------------ [2008-11-10 11:25:52] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2007-01-31 10:37:03] tony at marston-home dot demon dot co dot uk When I try the following: $stmt = ociParse($dbconn, "SELECT favourite_food FROM x_person"); oci_bind_array_by_name($stmt, 'favourite_food', $foods, 10, -1, SQLT_NUM); oci_execute($stmt); while(oci_fetch($stmt)) { print_r($foods); } it fails with ORA-01036: illegal variable name/number. When I try the following: $stmt = ociParse($dbconn, "SELECT :favourite_food FROM x_person"); oci_bind_array_by_name($stmt, ':favourite_food', $foods, 10, -1, SQLT_NUM); oci_execute($stmt); while(oci_fetch($stmt)) { print_r($foods); } it fails with ORA-01484: arrays can only be bound to PL/SQL statements. ------------------------------------------------------------------------ [2007-01-30 19:38:25] [EMAIL PROTECTED] You can and I've already pointed you out how to do it, but you don't want even to try. ------------------------------------------------------------------------ [2007-01-30 19:21:43] tony at marston-home dot demon dot co dot uk MySQL's SET datatype and PostgreSQL's ARRAY datatype are identical in functionality to Oracle's VARRAY datatype in that they can hold arrays of values instead of single values. It is not unreasonable of me to expect to be able to write to a SET/ARRAY/VARRAY column and read that data back again. I can do this with the TOAD admin tool and Oracle SQL Developer, so why can't I do it with the OCI8 extension? ------------------------------------------------------------------------ [2007-01-30 18:53:53] [EMAIL PROTECTED] >So just because I want to do something with Oracle that I >can already do with MySQL and PostgreSQL you call me >obstinate and pedantic? Oracle does not have SET or ENUM datatypes. Oracle does not support LIMIT clause. Oracle does not convert dates to strings and vice versa automatically. Oracle's SQL dialect is different from the dialects used in MySQL & PostgreSQL. There are much more things you CAN do in MySQL and/or Postgres, but CAN'T do in Oracle. Do you think they are PHP bugs too? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/40186 -- Edit this bug report at http://bugs.php.net/?id=40186&edit=1
