|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2011-04-18 10:31 UTC] johannes@php.net
-Status: Open
+Status: Assigned
-Assigned To:
+Assigned To: sixd
[2011-04-18 19:00 UTC] sixd@php.net
-Type: Bug
+Type: Feature/Change Request
[2017-10-24 07:56 UTC] kalle@php.net
-Status: Assigned
+Status: Open
-Assigned To: sixd
+Assigned To:
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 02 19:00:02 2025 UTC |
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