RE: dbms_utility.uncl_array
- From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- To: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>, Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Fri, 15 Oct 2010 12:45:33 -0700
Ahh...this was it..you need to terminate the array with a null...and that
worked....dang...
DECLARE
vSnapshotList dbms_utility.uncl_array;
BEGIN
vSnapshotList(1) := 'TABLE1';
vSnapshotList(2) := 'TABLE2;
vSnapshotList(2) := NULL;
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;
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Chuck Boddy
Sent: Friday, October 15, 2010 12:41 PM
To: Stefan Knecht
Cc: oracle-l-freelists
Subject: RE: dbms_utility.uncl_array
Hi Stefan,
You are probably right....when I've used single quotes..i've gotten this error
instead....not quite sure why?...any ideas...the object does exist...
Thanks,
Chuck
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_IREFRESH", line 820
ORA-06512: at "SYS.DBMS_REFRESH", line 84
ORA-06512: at line 90
From: Stefan Knecht [mailto:knecht.stefan@xxxxxxxxx]
Sent: Friday, October 15, 2010 12:33 PM
To: Chuck Boddy
Cc: oracle-l-freelists
Subject: Re: dbms_utility.uncl_array
Chuck,
vSnapshotList(1) := "TABLE1";
You don't want to be using double quotes there. Just normal single quotes.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx<mailto:s@xxxxxxxx>
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx<mailto:info@xxxxxxxx>
http://www.10046.ch
=========================
On Fri, Oct 15, 2010 at 9:21 PM, Chuck Boddy
<Chuck.Boddy@xxxxxxxxxxxxxxx<mailto:Chuck.Boddy@xxxxxxxxxxxxxxx>> wrote:
vSnapshotList(1) := "TABLE1";
Other related posts:
