Oracle bindValues \PDO::PARAM_LOB - error ORA-03131

Do in the console:


DECLARE

XXX CLOB;

BEGIN

XXX := TO_CLOB('1');

API.CHECK_ACCESS( I_SESSION_ID => '7842e55f7f512527dd943a621cc631b3', I_CONTROLLER => '/accounts/23748512907642398', I_METHOD => 'PUT', I_BODY => XXX, O_ERROR_CODE => NULL, O_ERROR_MSG => NULL); END;



Getting a result, there are no errors.

Run through the YII:




$result = \Yii::$app->db->createCommand($sql);

$result->bindValues([

':I_SESSION_ID' => [$I_SESSION_ID, \PDO::PARAM_STR, 255],

':I_CONTROLLER' => [$I_CONTROLLER, \PDO::PARAM_STR, 255],

':I_METHOD' => [$I_METHOD, \PDO::PARAM_STR, 255],

'<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/ohmy.gif' class='bbc_emoticon' alt=':o' />_ERROR_CODE' => [$O_ERROR_CODE, \PDO::PARAM_INT, 50],

'<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/ohmy.gif' class='bbc_emoticon' alt=':o' />_ERROR_MSG' => [$O_ERROR_MSG, \PDO::PARAM_STR, 255],

]);

$result = $result->query();

[/code]

Get the error:

SQLSTATE [HY000]: General error: 3131 OCIStmtExecute: ORA-03131: for the next part of the allocated buffer is invalid \ n (ext \\ pdo_oci \\ oci_statement.c: 148)

What is the error?

pdo error in PHP 5.2.12 ?

have you tried same code with pure php pdo?

PHP 5.4.8