DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Recompile invalid objects failed

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    Recompile invalid objects failed

    Hi,
    I was trying to recompile invalid objects and got the following error.
    Any idea?

    SQL> @d:\oracle\ora81\rdbms\admin\utlrp.sql
    from obj$ o, user$ u
    *
    ERROR at line 25:
    ORA-06550: line 25, column 17:
    PLS-00201: identifier 'OBJ$' must be declared
    ORA-06550: line 4, column 15:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 41, column 39:
    PLS-00201: identifier 'OBJ$' must be declared
    ORA-06550: line 41, column 2:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 4, column 24:
    PLS-00320: the declaration of the type of this expression is incomplete or
    malformed
    ORA-06550: line 50, column 6:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 68, column 39:
    PLS-00201: identifier 'OBJ$' must be declared
    ORA-06550: line 68, column 4:
    PL/SQL: SQL Statement ignored
    Last edited by Ablakios; 02-25-2004 at 11:31 AM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Please disregard the above post. I was running the script in a wrong schema.
    Sorry.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by Ablakios
    Please disregard the above post. I was running the script in a wrong schema.
    Sorry.
    D'OH!!

    I hate when that happens!!
    Especially when it is a truncate script!



    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Now if you had a login.sql that contained something like . . . .
    Code:
    column my_prom new_value myprom
    set termout off
    select lower(user)||'@'||lower(substr(global_name,1,4))||':'||lower(instance_name)||
    '-'||initcap(host_name)||chr(10)||'SQL> ' my_prom from global_name, v$instance;
    set sqlprompt '&myprom'

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    set line 130
    set serverout on
    set pagesize 40
    set termout off
    col plan_plus_exp for a96
    
    column sql_string new_value sql_string
    column sqlpr new_value sqlpr
    
    select case
           when isdba='DBA' or whoami='SYS'
           then 'lower(user) || ''@'' || instance_name || ''-'' || upper(host_name) sqlpr
                 from v$instance'
           when isdba is null
           then 'lower(user) || ''@'' || substr(global_name, 1, decode(instr(global_name, ''.'', -1, 1), 0,
                 length(global_name) + 1, instr(global_name, ''.'', -1, 1) ) - 1) sqlpr
                 from global_name'
           end sql_string
      from (select role isdba, user whoami
              from (select user whoami from dual) b,
                   (select user whoami, role from session_roles where role = 'DBA') a
             where a.whoami(+) = b.whoami);
     
    select &sql_string;
    
    set sqlprompt '&sqlpr>'
    
    alter session set nls_date_format='YYYYMMDD HH24:MI:SS';
    
    set termout on

  6. #6
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Yes Mr.Hanky I hate that too. but tkx to everyone. I will just set my sqlprompt environment.
    Thanks again everyone.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width