View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000746 | SymmetricDS | Improvement | public | 2012-08-01 19:22 | 2014-02-03 01:52 |
| Reporter | evfvadim | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.0.10 | ||||
| Target Version | 3.1.0 | Fixed in Version | 3.1.0 | ||
| Summary | 0000746: Improve documentation on how to handle Oracle error 'ORA-01489: result of string concatenation is too long' | ||||
| Description | This can happen during execution of generated table triggers or during initial load when source table does not have LOB columns and total length of data in a particular row exceeds 4000 bytes. The issue was also posted in the forum on 2011-09-14 by John Scattergood (jscattergood). | ||||
| Tags | No tags attached. | ||||
|
|
Have you tried to setting sym_channel.contains_big_lob=1? |
|
|
Yes, I've set it to 1 from the beginning. |
|
|
How about sym_trigger.use_capture_lobs=1? (and yes, the settings are confusing me too) |
|
|
Yes, that worked! Thanks. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-08-01 19:22 | evfvadim | New Issue | |
| 2012-08-01 19:36 | chenson | Note Added: 0000052 | |
| 2012-08-01 19:54 | evfvadim | Note Added: 0000053 | |
| 2012-08-01 20:00 | chenson | Note Added: 0000054 | |
| 2012-08-01 22:40 | evfvadim | Note Added: 0000055 | |
| 2012-08-01 23:39 | chenson | Summary | Oracle error 'ORA-01489: result of string concatenation is too long' => Improve documentation on how to handle Oracle error 'ORA-01489: result of string concatenation is too long' |
| 2012-08-01 23:40 | chenson | Category | Bug => Improvement |
| 2012-08-01 23:40 | chenson | Fixed in Version | => 3.1.0 |
| 2012-08-01 23:40 | chenson | Target Version | => 3.1.0 |
| 2012-08-01 23:41 | chenson | Assigned To | => chenson |
| 2012-08-01 23:41 | chenson | Status | new => assigned |
| 2012-08-01 23:41 | chenson | Status | assigned => resolved |
| 2012-08-01 23:41 | chenson | Resolution | open => fixed |
| 2012-08-14 11:57 | chenson | Status | resolved => closed |
| 2014-02-03 01:52 | Changeset attached | => SymmetricDS trunk r6130 | |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 193460c3 |