ORA-01722 Invalid Number in Webi Prompt

general discussion
1

Hi Everyone,

I have a Webi report. In that i have one of the filter condition as a Universe Condition, which has the below syntax.

@Select(ClassName\ Object Name) In @Prompt().

when i try to refresh this condition while running the query, i’m getting ORA-01722 Invalid Number error.

Kindly provide me some solution to resolve this error.

TIA

BOUSER890 (BOB member since 2013-04-30)

2

Without knowing what Object Name actually is, or what your prompt is, I would think that your object resolves to a number but your prompt is returning char data.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

3

Hi Debbie,

Thanks for your reply.

Both the objects in @Select and in @Prompt are Character objects.

To be specific, please find below the complete syntax of my universe condition.

@Select(ClassName\ObjectName) in @Prompt(‘Enter Value:’,‘A’,‘Classname\ObjectName’,multi, free)

This same condition is workinh without any issue in Desktop Intelligence report. But it is throwing error in Webi report.

Kindly help me to resolve this error.

Thanks,
PD

BOUSER890 (BOB member since 2013-04-30)

4

Hi PD,

We have faced samilar kind of issue with when we have converted desci reports in to webi reports.

One of the solution is append single quote to your prompt values in the table.

if table value is ABC convert it to ‘ABC’

Oracle cant understand the value type simply prompt retuturs alphbets with out quotes. without quotes it treats as number but actual value is character.
In deski it is not the case.

Thanks,
Jinkaleo.

jinkaleo :india: (BOB member since 2007-01-25)