error when upgrade to 11g
When I run catupgrd.sql I got the following error. Please help!
SQL> Rem *************************************************************************
SQL> Rem Remove obsolete Summary Advisor java classes
SQL> Rem *************************************************************************
SQL>
SQL> declare
2 cursor cur1 is
3 select owner, nvl(longname, object_name) from
4 dba_objects, javasnm
5 where object_type='JAVA CLASS' and
6 short(+)=object_name and
7 nvl(longname, object_name) like 'oracle/qsma/%';
8 l_owner varchar2(30);
9 l_name varchar2(4000);
10 l_buf varchar2(4000);
11 l_restart boolean;
12 begin
13 ------------------------------------------------------------------------------
14 -- We do the outer loop just in case we get a 'snapshot too old' error.
15 ------------------------------------------------------------------------------
16 loop
17 open cur1;
18
19 l_restart := FALSE;
20
21 loop
22 fetch cur1 into l_owner, l_name;