From: a dot vigetti at provincia dot grosseto dot it
Operating system: debian linux 2.6.12-1-686-smp
PHP version: 5.1.2
PHP Bug Type: OCI8 related
Bug description: can't insert al long raw column with php oci8
Description:
------------
Oracle library version 10G R2.
I need to insert into an oracle table with a long raw,
i can't change the column type because another application use the same
table and i can change the application.
I experinced the same problem with other version of php/oci libs/Oracle
database.
Reproduce code:
---------------
This is a small code example that fails:
<?php
/*
create table longRawTable( id number(10), fileimage long raw);
*/
$db=ocilogon("user","password", "database");
$qs = "insert into longRawTable (id, fileimage)" .
" values (:id, :fileimage)";
$stmt = OCIParse($db, $qs);
$i=1;
$fileimage = file_get_contents( "a_file" );
OCIBindByName ( $stmt, ":id", $i, -1);
OCIBindByName ( $stmt, ":fileimage", $fileimage, -1);
ociexecute($stmt, $OCI_DEFAULT);
ocicommit($db);
?>
When i try this script i obtain the following error:
Warning: ociexecute(): ORA-01461: can bind a LONG value only for insert
into a LONG column in ..../LongRow.php on line 13
Using a column of type LONG and storing data with the bin2hex function all
is OK.
Its a php or OCI problem?
I try a similar script in perl using DBD::Oracle on the same machine
linked with the same OCI libs without problems.
thanks
Aldo Vigetti
--
Edit bug report at http://bugs.php.net/?id=37059&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37059&r=trysnapshot44
Try a CVS snapshot (PHP 5.1):
http://bugs.php.net/fix.php?id=37059&r=trysnapshot51
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37059&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37059&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37059&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37059&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37059&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37059&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37059&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37059&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37059&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37059&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37059&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37059&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37059&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37059&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37059&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37059&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37059&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37059&r=mysqlcfg
