DBMS_MVIEW.REFRESH

[ac]

Dear ALL,

I updated a table in a materialized view and tried to execute this procedure DBMS_MVIEW.REFRESH_DEPENDENT(super,'EMP',' ',FALSE,FALSE)
but keep getting the following error messages:
line 2, column 32:
PLS-00201: identifier 'SUPER' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored

Can anyone tell me how to resolve this or declare 'SUPER'

AC

[bberg@rtnyc.com]

the docs show that your variable super
must be in of the type:
{ list IN VARCHAR2,
| tab IN OUT DBMS_UTILITY.UNCL_ARRAY,}

the uncl_array is also in the docs)...

LIST AND TAB are mutually exclusive... if super is a list then it is a varchar so it must be in quotes.

The dbms_mview.refresh is also an options if you like... you can refresh views that are invalid...

select object_name, object_Type from user_objects where status = 'INVALID';

note, the type is "UNKNOWN" for some reason.

hope this helped.

[ac]

Thanks for the suggestion but it didn't work. I also querried the dba_view_analysis but the materialized view wasn't there. I think the materialized wasn't registered in the first place. Can you tell me why and if possible how to register it. The materialized view was created.

The following parameters are needed to execute DBMS_MVIEW.REFRESH_DEPENDENT(failures, 'table_name','A','RBS002',FALSE,FALSE). What paramer do I need to supply in place of failures?.

[Edited by ac on 06-03-2001 at 06:18 AM]