Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Unanswered: Recompile invalid object type

    Hi Everyone,

    I am facing an issue while executing following statement.

    CREATE OR REPLACE
    TYPE type2
    AUTHID CURRENT_USER
    UNDER type1
    (
    defid INTEGER
    , OVERRIDING MEMBER FUNCTION apply( SELF IN OUT NOCOPY type2 ) RETURN BOOLEAN
    )
    NOT FINAL;
    /


    The cursor waits for some time and then shows a message:

    ORA-03113: end-of-file on communication channel


    Here type2 does not have any subtype and it is dependent on type1. All the objects are valid except the type 'type2'.

    The 'type2' has a valid type body as well. How can this type2 be re-compiled?

    Thanks in advance,
    Kaushik
    kaushik mitra

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
    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
    Aug 2009
    Posts
    262
    ORA-03113:
    end-of-file on communication channel
    Cause: The connection between Client and Server process was broken.
    Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.


    bugg?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
    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.

Tags for this Thread

Posting Permissions

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