dbms_mview.refresh question

From: Rob K <robkato_at_earthlink.net>
Date: Fri, 29 Jun 2001 14:55:46 GMT
Message-ID: <SF0%6.3331$ck5.359136@newsread2.prod.itd.earthlink.net>

I have a procedure in dwp1 schema that executes the dbms_mview.refresh procedure.
If I grant execute on that procedure and run the procedure from another user I get the following errors.

SQL> exec mview_refresh
BEGIN mview_refresh; END;

*
ERROR at line 1:

ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1046
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1028
ORA-06512: at "DWP1.MVIEW_REFRESH", line 10
ORA-06512: at line 1

I don't get any errors if I run it under the dwp1 schema.

Thanks Rob Received on Fri Jun 29 2001 - 09:55:46 CDT