Ora-00920 Invalid Relational Operator

building semantic layer
1

Does anyone have any idea why this condition should cause an
Ora-00920.

@Select(Accounting\Go) IN @Prompt(‘GO: ‘,‘A’,‘Accounting\Go’,multi,) OR
@Select(Accounting\Go)LIKE
UPPER (’%’ ||@Variable('GO: ')|| ‘%’) OR
@Select(Accounting\All Acctg) IN @Variable('GO: ')

mvbokker (BOB member since 2002-09-03)

2

Try removing

@Select(Accounting\Go)LIKE 
UPPER ('%' ||@Variable('GO: ')|| '%')

from your condition/sql. Does it run now?

If so check out the thread “case insensitive prompt”

Andreas :de: (BOB member since 2002-06-20)