Bug
Error when using MULTILINESTRING constructor in ST_Geometry on Oracle with more than 4000 characters.
| Bug ID Number | NIM056702 |
|---|---|
| Submitted | April 24, 2010 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 9.3 |
| Operating System | Windows OS |
| Operating System Version | XP |
| Status | Known Limit |
Additional Information
Passing VARCHAR2 Parameter Longer Then 4000 Characters To SQL Function Inside A SQL Statement ends up with ORA-1460 or ORA-1461 [Oracle ID 300268.1]Workaround
Execute the insert in a seperate command than the Shape constructorChange: INSERT INTO lines_test VALUES (1,sde.st_linestring(user_name,0));To: shape := sde.st_mlinefromtext(user_name,0); INSERT INTO lines_test VALUES (1,sde.st_linestringshape,0));Steps to Reproduce
Bug ID: NIM056702
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App