Oracle 12c: Procedure created but does not exist

From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Wed, 15 Jul 2015 11:05:24 +0200
Message-ID: <55A62254.40705_at_mgm-tp.com>



Hello,

has anyone seen this before?

I'm creating a procedure and SQL*Plus claims it has been created and I can execute it, but it doesn't show up in user_procedures and there is no source code in user_source

  • start SQL*Plus transcript ------

  SQL> select * from v$version;

  BANNER                                                                               CON_ID
  -------------------------------------------------------------------------------- ----------
  Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0
  PL/SQL Release 12.1.0.2.0 - Production                                                    0
  CORE    12.1.0.2.0      Production                                                        0
  TNS for 64-bit Windows: Version 12.1.0.2.0 - Production                                   0
  NLSRTL Version 12.1.0.2.0 - Production                                                    0

  5 rows selected.

  SQL> show con_id;

  CON_ID



  3

  SQL> create or replace procedure cleanup     2 as
    3 begin
    4 delete from person
    5 where last_contacted < current_timestamp - interval '1' year;     6 commit;
    7 end;
    8 /

  Procedure created.

  SQL> select object_name from user_objects where object_type = 'PROCEDURE';

  OBJECT_NAME



  CLEANUP   1 row selected.

  SQL> select object_name, object_type
    2 from user_procedures;

  no rows selected

  SQL> select * from user_source;

  no rows selected

  SQL> execute cleanup;

  PL/SQL procedure successfully completed.

  SQL>

  • end SQL*Plus transcript ------

Any ideas?

This is an Oracle12c installation with a single pluggable database on my Windows laptop.

Regards
Thomas

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 15 2015 - 11:05:24 CEST

Original text of this message