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

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

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!