Oracle Reports (MOSC)

MOSC Banner

error when using brackets in in nested query in report builder

edited Dec 17, 2009 8:11AM in Oracle Reports (MOSC) 9 commentsAnswered
 Hi using report builder 10.1.0.4.2

when we use a nested query as below it works fine in report builder

select t.id, id (select td.desc from td where td.trd_id = t.id and td.desc = 'AAA') desc from t;

however

when we include brackets in the nested query as in the example below with nvl report builder throws an error.

select t.id, id (select td.value from td where td.trd_id = t.id and nvl(td.desc, 'AAA') = 'AAA') value from t;

The error stack is

REP-0069 - Internal Error

REP 57054 - IN Process job Terminated

REP -300 Oracle error

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center