CSV Load ORA-06550 PLS 00103 error


	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'))

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!