numeric or value error: character string buffer too small - PHP + Oracle

Question

Below is my procedure

NOBL_TEC_TEST_PROC(v1 number,v2 out number)

my model function

public function testProc()
{
    $result = '';
    $db = "orcl";
    $conn = oci_connect("***", "****", $db);
    $sql = 'begin NOBL_TEC_TEST_PROC(222, :seqno); end;';
    $stmt = oci_parse($conn,$sql);
    oci_bind_by_name($stmt, ':seqno', $result);
    oci_execute($stmt);

    return $result;

}

if I give the IN value <10 it is working fine, but when I try to give IN value >10 it is giving following error.

<b>Warning</b>:  oci_execute(): ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 in....

How can I fix this? Any help? Thanks

You need to change the procedure.... you're assigning one of your parameters to a local variable in that procedure (or in something that procedure calls etc). The local variable does not have the correct datatype to accept what you are passing... you're going to have to change it. — Ben
How should I change the procedure? am a php developer so I dont really know.. — vamsi
If you post the procedure then someone will be able to help... changing it might have knock on effects though so it's best to ask the person responsible for it. — Ben

Nardus Grobler Nardus Grobler · Accepted Answer · 2014-04-14T11:44:23

I Know its a little late, but you need to add your buffer size to your oci_bind_by_name

oci_bind_by_name($stmt, ':seqno', $result,2000);

This should solve your issue

numeric or value error: character string buffer too small - PHP + Oracle

3 Answers