View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0016336 | mantisbt | db oracle | public | 2013-08-28 10:54 | 2014-12-08 00:34 |
Reporter | dregad | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0016336: File attachment to DB fails when file bigger than 4000 bytes on Oracle | ||||
Description | When trying to upload a file bigger than 4000 bytes while storing attachments in the DB, Oracle throws error ORA-01461: can bind a LONG value only for insert into a LONG column for the query | ||||
Tags | No tags attached. | ||||
Oracle requires special handling for BLOB data. Insertion "in-line" is limited to 2000 bytes, and with bind variable it is only possible when data is < 4000 bytes. |
|
With the commits I pushed today, the Oracle branch [1] should now properly support db-stored attachments. See 0016331 for similar fix for disk-stored attachments. |
|
MantisBT: master f3552d42 2013-08-28 07:00 Details Diff |
Database api: new db_update_blob() function Issue 0016336 |
Affected Issues 0016336 |
|
mod - core/database_api.php | Diff File | ||
MantisBT: master b36ff709 2013-08-28 07:01 Details Diff |
Oracle: properly store file attachments as BLOBs Uses new db_update_blob() function, instead of relying on hex-encoding the binary data and passing the resulting string to db_query_bound() because this method limits the size of attachments to 4000 bytes. Fixes 0016336 Porting to 1.3 - Conflicts: core/file_api.php |
Affected Issues 0016336 |
|
mod - core/database_api.php | Diff File | ||
mod - core/file_api.php | Diff File |