RE: dbms_utility.uncl_array

From: Chuck Boddy <Chuck.Boddy_at_gettyimages.com>
Date: Fri, 15 Oct 2010 12:54:21 -0700
Message-ID: <8DC04761D4E2734EA65935501DB2C8E3013124CB10B8_at_SEAPXCH7MBX01.amer.gettywan.com>

No problem....
Thanks for the response Stefan....you provided the sanity check with " vs '

Thanks again,
Chuck

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Knecht Sent: Friday, October 15, 2010 12:47 PM
To: Chuck Boddy
Cc: oracle-l-freelists
Subject: Re: dbms_utility.uncl_array

Ahh ok

Ignore the previous mail then :)

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch<mailto:s_at_10046.ch>

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch<mailto:info_at_10046.ch> http://www.10046.ch

---

On Fri, Oct 15, 2010 at 9:46 PM, Stefan Knecht <knecht.stefan_at_gmail.com<mailto:knecht.stefan_at_gmail.com>> wrote: Hi Chuck

Not very much familar with dbms_refresh and its internals, but it seems like something is missing.

But it does appear as it's actually starting to run, compared to the first errors you mentioned.

What you can do to further diagnose it is:

alter session set events '1403 trace name errorstack level 1';

Then, run your statement again, and check the tracefile generated in udump for the Current SQL statement, as well as the errorstack. This may lead to further hints about what's going on.

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch<mailto:s_at_10046.ch>

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch<mailto:info_at_10046.ch> http://www.10046.ch

---

On Fri, Oct 15, 2010 at 9:40 PM, Chuck Boddy <Chuck.Boddy_at_gettyimages.com<mailto:Chuck.Boddy_at_gettyimages.com>> wrote: 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_at_gmail.com<mailto:knecht.stefan_at_gmail.com>] 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_at_10046.ch<mailto:s_at_10046.ch>

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch<mailto:info_at_10046.ch> http://www.10046.ch

---

On Fri, Oct 15, 2010 at 9:21 PM, Chuck Boddy <Chuck.Boddy_at_gettyimages.com<mailto:Chuck.Boddy_at_gettyimages.com>> wrote: vSnapshotList(1) := "TABLE1";

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 15 2010 - 14:54:21 CDT