Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    11

    Unanswered: ORA-00604 Error SQL recursif 1

    Hi after running

    create table x as select * from cdc;
    I receive the following error message

    ORA-00604: Une erreur s'est produite au niveau SQL récursif 1
    ORA-04068: état de packages existant rejetés
    ORA-04063: package body "SYS.DBMS_CDC_PUBLISH" a des erreurs
    ORA-06508: PL/SQL : Impossible de trouver unité de programme appelé
    ORA-06512: à ligne 3

    Does someone give me a help to resolve these problem.
    My oracle version is 9.2.0.4 on AIX 5.3

    Regards

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Try:
    Code:
    Alter package "SYS.DBMS_CDC_PUBLISH" compile;
    show error



    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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