This content has been marked as final. Show 10 replies
yxes2013 wrote:Here is one example, take a look http://www.jusungyang.com/DWfolder/MaterializedViews/FunctionAndQueryRewrite.txt
I am creating a materialized view with query rewrite, but it failed on a column conversion. How do I make work around for this column please....
I thank you all,
TO_CHAR(DECODE (SALARY, 0, 0, TRUNC (COMM / INCENT * 100, 2) ),'FM999.00') turnout, * ERROR at line 7: ORA-30357: this PL/SQL function cannot be supported for query rewrite
How can I make the functional column - DETERMINISTIC?
ORA-30357: this PL/SQL function cannot be supported for query rewrite Cause: The statement referenced a PL/SQL function that is not marked DETERMINISTIC. Action: Perform one of the following actions: - Remove the use of the PL/SQL function. - Mark the PL/SQL function as DETERMINISTIC. - Disable the REWRITE option on the materialized view. The function should be marked DETERMINISTIC only if it always returns the same result value for any given set of input argument values, regardless of any database state or session state. Do not mark the function as DETERMINISTIC if it has any meaningful side-effects.
Here is one example, take a look http://www.jusungyang.com/DWfolder/MaterializedViews/FunctionAndQueryRewrite.txtI can not understand this example dear :(
Can you just give me workaround on how to fix this?
TO_CHAR(DECODE (SALARY, 0, 0, TRUNC (COMM / INCENT * 100, 2) ),'FM999.00') turnout,What is the purpose of query rewrite anyway? :(
ERROR at line 7:
ORA-30357: this PL/SQL function cannot be supported for query rewrite
If I remove it, what will happen to my materialized view?
Thanks a lot,
yxes2013 wrote:You shouldn't had mentioned here too! You never know that he is going to come looking for some answers on an Oracle foum ;-) .
ooops my apologies, I think the problem is with our network thats why its very slow. I am downloaded a big file like 2Gb :D
The network admin rebooted our network server, not telling him I am the culprit.
I just heard him blaming someone downloading big files.