Edit report at https://bugs.php.net/bug.php?id=62551&edit=1
ID: 62551 Updated by: php-bugs@lists.php.net Reported by: tbrillaud at meti dot fr Summary: oci_bind_by_name() : maxlength and memory usage -Status: Feedback +Status: No Feedback Type: Bug Package: OCI8 related Operating System: Linux PHP Version: 5.3.14 Assigned To: sixd New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2012-10-03 02:37:19] s...@php.net Please give a complete testcase, including the DDL to create the procedure showing the datatype being using. ------------------------------------------------------------------------ [2012-07-13 12:54:01] tbrillaud at meti dot fr Description: ------------ The variable maxlength has no effect in the memory usage for a bind variable OUT. A bind variable OUT takes systematically 65536 bytes in memory. Test script: --------------- $sql = "CALL TEST.PROC_OUT(:OUT)"; $curseur = oci_parse($connexion, $sql); $out="1"; $size=10; oci_bind_by_name($curseur,":OUT", $out, $size); var_dump(memory_get_usage()); $ok = oci_execute($curseur); oci_free_statement($curseur); var_dump(memory_get_usage()); Expected result: ---------------- Memory should be consistency with the maxlength parameter. Actual result: -------------- Playing with memory settings, we obtain : PHP Fatal error: Allowed memory size of 10752000 bytes exhausted (tried to allocate 65536 bytes) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=62551&edit=1