PL/SQL (MOSC)

MOSC Banner

How to find the pl/sql code for the package and package body

edited Jan 31, 2010 1:23PM in PL/SQL (MOSC) 7 commentsAnswered
 SQL> select object_name, object_type, created, status, last_ddl_time from dba_objects where owner='TICCRM';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         CREATED   STATUS  LAST_DDL_
------------------- --------- ------- ---------
PLAN_TABLE
TABLE               22-JAN-10 VALID   22-JAN-10

PROCEDURE
PROCEDURE           12-JAN-10 INVALID 12-JAN-10

PROCESS_ITEMS_PK
PACKAGE             20-JAN-10 VALID   20-JAN-10


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         CREATED   STATUS  LAST_DDL_
------------------- --------- ------- ---------
PROCESS_ITEMS_PK
PACKAGE BODY        20-JAN-10 VALID   25-JAN-10

I need to find out the pl/sql code for the process_items_pk package and package body since I did not write this. Is there a way to find that out through sqlplus? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center