Bug #74078 [NEW]: oci_new_collection not found

From: Date: Fri, 10 Feb 2017 14:55:16 +0000
Subject: Bug #74078 [NEW]: oci_new_collection not found
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-207254@lists.php.net to get a copy of this message
From: raphgivernaud at yahoo dot fr Operating system: Windows PHP version: 5.6.30 Package: OCI8 related Bug Type: Bug Bug description:oci_new_collection not found Description: ------------ When trying to use the "oci_new_collection" function with "RECORD" of PL / SQL, the type is never found. If we try to use "oci_bind_array_by_name" instead, as proposed in #38791, then the execution of the procedure returns that the type is bad or unknown. Test script: --------------- /* Oracle */ CREATE OR REPLACE PACKAGE OPS$AGIX1NSG.pk_g_v AS TYPE T_V IS RECORD ( nm h1v.nm%TYPE, nmp h1v.nmp%TYPE, no h1v.no%TYPE, user h1v.user%TYPE ); FUNCTION rech (pr_NO IN VARCHAR2, pr_DATE IN DATE, pr_V OUT T_V) RETURN NUMBER; END pk_g_v; /* Php */ $stid = oci_parse($conn, "begin :r_NBRESULT := pk_g_v.rech('3208010896', TO_DATE('27/01/2017', 'DD/MM/YYYY'), :pr_V); end;"); $pr_V = oci_new_collection($conn, 'T_V', 'PK_G_V'); oci_bind_by_name($stid, ':pr_V', $pr_V, -1, SQLT_REC); oci_bind_by_name($stid, ':r_NBRESULT', $r_NBRESULT); Actual result: -------------- PHP Warning: oci_new_collection(): OCI-22303: type "PK_G_V"."T_V" not found in ... -- Edit bug report at https://bugs.php.net/bug.php?id=74078&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74078&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74078&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74078&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74078&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74078&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74078&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74078&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74078&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74078&r=support Expected behavior: https://bugs.php.net/fix.php?id=74078&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74078&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74078&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74078&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74078&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74078&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74078&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74078&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74078&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74078&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74078&r=mysqlcfg

« previous php.bugs (#207254) next »