RE: dbms_utility.uncl_array
- From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Fri, 15 Oct 2010 12:40:57 -0700
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:
