php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #47281 $php_errormsg is limited in size of characters
Submitted: 2009-02-02 18:08 UTC Modified: 2010-02-03 20:35 UTC
From: jeffersongranatto at mannesoft dot com dot br Assigned: sixd (profile)
Status: Closed Package: OCI8 related
PHP Version: 5.3.1 OS: Linux
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jeffersongranatto at mannesoft dot com dot br
New email:
PHP Version: OS:

 

 [2009-02-02 18:08 UTC] jeffersongranatto at mannesoft dot com dot br
Description:
------------
Sometimes, I need to show a big error message on a trigger of Oracle. Oracle supports this type of situation, but $php_errormsg does not display more than 500 characters.

Reproduce code:
---------------
create procedure sp_test as
begin
  raise_application_error(-20000, 'more than 500 characters');
end;


$stmt = ociparse($conn, 'begin sp_test; end;');
ociexecute($stmt, OCI_DEFAULT);
echo $php_errormsg;


Expected result:
----------------
The full message.

Actual result:
--------------
The message truncated to 500 characters.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-12-27 17:03 UTC] jeffersongranatto at mannesoft dot com dot br
Solution:

In ext/oci8/oci8.c, change the value of the constant PHP_OCI_ERRBUF_LEN to 1024. It's the biggest message that Oracle can return.
 [2009-12-29 14:47 UTC] johannes@php.net
Chris, please check this.
 [2010-01-05 04:43 UTC] sixd@php.net
Confirmed.
 [2010-01-07 23:59 UTC] svn@php.net
Automatic comment from SVN on behalf of sixd
Revision: http://svn.php.net/viewvc/?view=revision&revision=293235
Log: Bug #47281 ( is limited in size of characters).  Also remove redundant code line.
 [2010-02-03 20:08 UTC] svn@php.net
Automatic comment from SVN on behalf of pajoye
Revision: http://svn.php.net/viewvc/?view=revision&revision=294447
Log: Bug #47281 ( is limited in size of characters). Also remove redundant code line
 [2010-02-03 20:35 UTC] sixd@php.net
Fixed in PHP 5.3.2 and PECL OCI8 1.4.1
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 12:01:29 2024 UTC