ORA-04063 table has errors from a function's cursor
brunixMay 13 2008 — edited May 13 2008Hallo everybody,
I have this problem....
I create a function with a cursor inside.
Executing this function I have the "ORA-04063 table ....has errors" but if I execute the cursor select from an sqlplus console all goes good.
The only strange thing is that the table mentioned in the ORA-04063 error belong to a different tablespace.
There were some particular grant to assign to the user who execute the function ?
Thanks in advance,
Brunix