| Applies To | |||
| Product(s): | Exor Core / Network / Assets Manager | ||
| Version(s): | 4.2.0.0 | ||
| Environment: | N/A | ||
| Area: | N/A | ||
| Subarea: | N/A | ||
| Original Author: | Bentley Technical Support Group | ||
Problem
Error when running CSV Load: ORA-06550: line 72, column 84: PLS-00103: Encountered the symbol ";" when expecting one of the following: . ( ) , * % & | = - + < / > at in is mod remainder not range rem => .. <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ as between from using || multiset member SUBMULTISET_ The symbol ")" was substituted for ";" to continue.
Solution
Error was caused by a mistake in the syntax of the 'source column' entry in hig2020 - CSV Loader File Definitions Tables. It can be that a bracket is missing from a statement similar to
this:
UPPER(NVL(TRIM(TABLE.COLUMN,'UNKNOWN')) should have been UPPER(NVL(TRIM(TABLE.COLUMN),'UNKNOWN'))
See Also
External Links
Bentley Technical Support KnowledgeBase
Comments or Corrections?
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!