|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-05-16 13:48 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 14:00:01 2025 UTC |
Description: ------------ When i try update BLOB(or CLOB) i receive oracle error. This error persist in php4( Warning: ociexecute(): OCIStmtExecute: ORA-01465: invalid hex number in c:\inetpub\wwwroot\test3.php4 on line 7) I use Oracle 10 database Reproduce code: --------------- <?php $data = 'Some data'; $conn = oci_connect('test', 'test', 'test'); $query = "UPDATE TEST SET BL = :tst WHERE ID = 1"; //BL - field with type BLOB $stid = oci_parse($conn, $query); oci_bind_by_name($stid, ':tst', $data); $r = oci_execute($stid); if ($r) print "One row updated"; oci_close($conn); ?> Expected result: ---------------- One row updated Actual result: -------------- Warning: oci_execute() [function.oci-execute]: ORA-01465: invalid hex number in /home/shagren/public_html/oracle10/test3.php on line 9