dbms_utility.uncl_array
- From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2010 12:21:52 -0700
Hi,
Can someone see why I'm getting the following error...thought I was using this
utility correctly..obviously not...
Thanks,
Chuck
DECLARE
vSnapshotList dbms_utility.uncl_array;
BEGIN
vSnapshotList(1) := "TABLE1";
vSnapshotList(2) := "TABLE2";
DBMS_REFRESH.MAKE(name => 'TEST_REFRESH,
tab => vSnapShotList,
next_date => NULL,
interval => NULL,
implicit_destroy => FALSE,
lax => FALSE,
job => 0,
purge_option => NULL,
parallelism => NULL,
heap_size => NULL);
end;
/
END;
PLS-00357: Table,View Or Sequence reference 'TABLE1' not allowed in this context
PLS-00357: Table,View Or Sequence reference 'TABLE2' not allowed in this context
Other related posts:
