Edit report at http://bugs.php.net/bug.php?id=54553&edit=1
ID: 54553 Updated by: [email protected] Reported by: richard dot strba at email dot cz Summary: OCI-Collection::getelem() Unknown or unsupported type of element -Status: Open +Status: Assigned Type: Bug Package: OCI8 related Operating System: Windows XP Professional SP3 PHP Version: 5.3.6 -Assigned To: +Assigned To: sixd Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2011-04-18 02:21:20] richard dot strba at email dot cz Description: ------------ function OCI-Collection::getelem() returns "Unknown or unsupported type of element: 108 when collection returned from oracle sql stored function. database version is 10g Release 2 Test script: --------------- SQL: CREATE TABLE AAAPOKUS2 ("COLUMN1" VARCHAR2(20 BYTE) ) TABLESPACE "USERS" ; CREATE OR REPLACE TYPE AAATYPE1 AS object ( column1 VARCHAR2(20 CHAR) ); CREATE OR REPLACE TYPE AAATYPE1_TABLE is table of AAATYPE1; CREATE OR REPLACE FUNCTION FUNCTION3 ( PARAM2 OUT AAATYPE1_TABLE ) RETURN number AS BEGIN SELECT AAATYPE1(column1) bulk collect into PARAM2 FROM AAAPOKUS1; RETURN 8; END FUNCTION3; PHP: $query = " BEGIN :v_Return := FUNCTION3(:PARAM2);end;\n"; $s = oci_parse($conn, $query); $var3 = ' 3'; $collection = oci_new_collection($conn,"AAATYPE1_TABLE","KSM"); oci_bind_by_name($s, ":PARAM2", $collection,-1,OCI_B_NTY); oci_bind_by_name($s, ":v_Return", $var3); oci_execute($s, OCI_DEFAULT); echo($collection->size()); $elem = $collection->getElem(1); Expected result: ---------------- expected is some values (array of values) returned from stored function Actual result: -------------- false ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=54553&edit=1
