RE: dbms_utility.uncl_array
- From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- To: "knecht.stefan@xxxxxxxxx" <knecht.stefan@xxxxxxxxx>
- Date: Fri, 15 Oct 2010 12:54:21 -0700
No problem....
Thanks for the response Stefan....you provided the sanity check with " vs '
Thanks again,
Chuck
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@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:46 PM, Stefan Knecht
<knecht.stefan@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>> 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@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:40 PM, Chuck Boddy
<Chuck.Boddy@xxxxxxxxxxxxxxx<mailto:Chuck.Boddy@xxxxxxxxxxxxxxx>> 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@xxxxxxxxx<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:
