Thursday, 16 October 2008

Why "#OWNER#" in APEX interactive report ??

The default APEX generated interactive report has "#OWNER#" instead of the schema name...

Now, I'm not sure how that helps and this might be a bug as I cannot seem to be able to calculate any other columns (by using the COMPUTE feature of the interactive report). I kept getting this message:
"Invalid computation expression. ORA-00942: table or view does not exist".

When I removed the "#OWNER#.", miraculously the COMPUTE feature started working.

hmmm... this sure is one of the mysteries of APEX....

No comments: