i have a mview created in one of the schemas and i want to pass the name of the mview to a procedure of a package and i get the following error: -
ORA-20100: DRA.MV_BC_DEPT Not registered, see log for details.
ORA-06512: at "DRA.BIP_DELTA_PD", line 75
ORA-06512: at line 17
Any idea how to resolve this, do i have to give any permissions to the mview created??
thanks and regards,
Prasenjit