ID: 4296 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Closed Bug Type: Oracle related Operating System: Linux PHP Version: 4.0 Release Candidate 1 New Comment:
Linux +Apache + php 4.0.8 + Oracle 8.1.5.0.2 My oracle table has a LONG field (str_out). The statement to obtain filed works as long as strlen(str_out) < 32067, otherwise i get error from oracle. I suppose that Oracle not work with fields LONG greater then 32067. Previous Comments: ------------------------------------------------------------------------ [2000-08-18 13:06:43] [EMAIL PROTECTED] Closed due to missing user feedback. ------------------------------------------------------------------------ [2000-07-27 18:10:51] [EMAIL PROTECTED] Did you get your trace? ALso please try latest version of php (4.0.1pl2) and see if the problem still is there. ------------------------------------------------------------------------ [2000-05-02 17:29:20] [EMAIL PROTECTED] Linux + Oracle 8.1.5.0.2 The following block works: $query = "INSERT INTO messages VALUES ($num, :msg_body)"; $msg_body = stripslashes($msg_body); $stmt = OCIParse($cnx, $query); OCIBindByName($stmt, ":msg_body", &$msg_body, -1); OCIExecute($stmt); Replacting the 4th line by: OCIBindByName($stmt, ":msg_body", &$msg_body, -1, OCI_B_CLOB); My oracle table has a CLOB field (for msg_body). This first statement works as long as strlen($msg_body) < 32067. I suppose I need the second one to fix my length problem but then Apache core dumps. Trying to get a trace ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=4296&edit=1