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

Reply via email to