BOXIR3 prompt syntax error

building semantic layer
1

I am using the following syntax in the conditon object:

CLASS_1.OBJ_1 IN substr(@Prompt(‘Enter Value:’,‘A’,‘Class_1\Obj_1’,multi,free),1,1)

The syntax is getting parsed successfully in BOXIR2.
It is giving the following error while parsing in BOXIR3:

“Parse failed: Exception: DBD, ORA-00907: missing right parenthesis”

Any solution for this problem?
Thanks in Advance.

SRR (BOB member since 2009-01-20)

2

Hi,

The Substr() function takes only one input parameter so it does not work with a prompt with MULTI keyword.

Either change MULTI to MONO or remove the SUBSTR() function that is around the prompt.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks for the quick response.

Even after replacing multi to mono, its not getting parsed.

Even though the condition object is not getting parsed, the report is working fine.

I guess I have to remove substr(), to get it parsed successfully.

SRR (BOB member since 2009-01-20)

4

What about an INSTR() type function instead? Your SUBSTR example made little sense to me, but you shield be able to use an iNSTR or POS type function that gives you the starting position of your match. If it’s greater than 0, you have a match.

Oracle syntax:

nvl( instr( @prompt(...), table.col ), 0) > 0

digpen :us: (BOB member since 2002-08-15)

5

Thanks.
The logic is absolutely fine.
But i am getting the same error after using INSTR.

SRR (BOB member since 2009-01-20)