Edit report at https://bugs.php.net/bug.php?id=62551&edit=1
ID: 62551 Updated by: s...@php.net Reported by: tbrillaud at meti dot fr Summary: oci_bind_by_name() : maxlength and memory usage -Status: Open +Status: Feedback Type: Bug Package: OCI8 related Operating System: Linux PHP Version: 5.3.14 Block user comment: N Private report: N New Comment: Please give a complete testcase, including the DDL to create the procedure showing the datatype being using. Previous Comments: ------------------------------------------------------------------------ [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
