Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    8

    Unanswered: package timestamps

    In the user_objects table an object has a timestamp. My question is when is the date in the timestamp column set for packages and package bodies???

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Here is what the manual says
    http://download.oracle.com/docs/cd/B...5.htm#i1583352

    "TIMESTAMP VARCHAR2(20) Timestamp for the specification of the object (character data) "

    but I am not clear on what it means.

    below is from one of my DBs:
    Code:
      1  select OBJECT_NAME  ,OBJECT_TYPE , CREATED    , LAST_DDL_TIME , TIMESTAMP  from user_objects
      2  where object_type like 'P%'
      3* and LAST_DDL_TIME <> TIMESTAMP
    SQL> /
    
    OBJECT_NAME                    OBJECT_TYPE         CREATED             LAST_DDL_TIME       TIMESTAMP
    ------------------------------ ------------------- ------------------- ------------------- -------------------
    COMPARE_DIMMENTIONS            PROCEDURE           2006-11-17 11:25:01 2007-01-10 14:36:31 2007-01-10:12:07:50
    CONVERSION                     PACKAGE             2006-08-31 12:07:49 2006-08-31 12:07:57 2006-08-31:12:07:49
    LIFETIME                       PACKAGE             2006-08-31 12:07:49 2006-08-31 12:07:57 2006-08-31:12:07:49
    LOAD_DIMMENTIONS               PROCEDURE           2006-11-22 16:58:58 2007-01-10 15:31:04 2007-01-10:15:30:51
    LOAD_FACTS                     PROCEDURE           2006-11-22 16:58:59 2007-04-23 20:20:33 2007-01-22:16:22:46
    LOAD_FACT_CHUNKS               PROCEDURE           2006-11-22 16:58:59 2007-01-05 14:42:54 2007-01-05:14:42:53
    LOAD_FACT_CHUNKS_BBY           PROCEDURE           2006-11-22 17:22:07 2006-11-22 17:38:02 2006-11-22:17:38:01
    TURN_PARALLEL                  PROCEDURE           2006-09-05 17:34:45 2006-09-05 17:36:33 2006-09-05:17:35:50
    
    8 rows selected.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2006
    Posts
    8
    No I am also not clear on what it means or when it happens, we are running forms 6 against a 9 data base and we are getting the following error when running forms after release to our live environment:
    FRM 40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-04062.
    I have tried a few things to resolve the issue but I thought I might do better if I fully understood what causes the problem.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You might find a clue here:
    http://www.psoug.org/reference/db_link.html

    Section on "Managing remote dependencies for functions, packages, procedures, and types"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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