Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"case when not m[1] is present then" outputs ORA-03113

Aketi JyuuzouMar 20 2009 — edited Jan 13 2011
I find that "case when not m[1] is present then" outputs ORA-03113:
Why?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
select * from dual model
 dimension by(0 as d)
 measures(1 as m)
 rules(
 m[any] = case when not m[1] is present then 1 end);
ORA-03113:
Below one is alterNative solution.
select * from dual model
 dimension by(0 as d)
 measures(1 as m)
 rules(
 m[any] = case when presentv(m[1],1,0) = 0 then 3 end);

D  M
-  -
0  3
This post has been answered by Solomon Yakobson on Mar 20 2009
Jump to Answer

Comments

dvohra21

What is the JDev, and BI publisher versions?

Abdelrahman ElGiar

j dev Ver : 12.2.1.2
BI Ver : 12.2.1.4
I found that I can use a dynamic BIP data source any reference for how to use it?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 10 2011
Added on Mar 20 2009
8 comments
2,547 views