Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00904: (Oracle 10g)
ORA-00904: [message #355002] Wed, 22 October 2008 03:19 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
When executing the query i am getting the following error.
I searched for that error code but not success yet.
SELECT distinct 
                   s.START_DATE, 
                   p.propagation_name,
                   s.PROPAGATION_WINDOW, 
                   s.NEXT_TIME, 
                   s.LATENCY,
                   DECODE(s.SCHEDULE_DISABLED,
                            'Y', 'Disabled',
                            'N', 'Enabled') SCHEDULE_DISABLED,
                   s.PROCESS_NAME,
                   s.FAILURES,
                   sysdate, 
                   s.LAST_ERROR_MSG 
           FROM    DBA_QUEUE_SCHEDULES s, 
                   DBA_PROPAGATION p
           WHERE   p.DESTINATION_DBLINK = s.DESTINATION
           AND     s.SCHEMA = p.SOURCE_QUEUE_OWNER
           AND     s.QNAME = p.SOURCE_QUEUE_NAME
           AND     (s.SCHEDULE_DISABLED='Y'
           OR      s.START_DATE > sysdate 
           OR      PROCESS_NAME is not null
           OR      s.FAILURES > 0
           OR      ERROR_MESSAGE is not null
           OR      LAST_ERROR_MSG is not null);

Error
ORA-00904: "DBMS_LOGREP_UTIL"."CANONICAL_CONCAT": invalid identifier


Thanks,
Re: ORA-00904: [message #355005 is a reply to message #355002] Wed, 22 October 2008 03:42 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi ora,

It's not throwing any error for me :

SQL> SELECT distinct 
  2                     s.START_DATE, 
  3                     p.propagation_name,
  4                     s.PROPAGATION_WINDOW, 
  5                     s.NEXT_TIME, 
  6                     s.LATENCY,
  7                     DECODE(s.SCHEDULE_DISABLED,
  8                              'Y', 'Disabled',
  9                              'N', 'Enabled') SCHEDULE_DISABLED,
 10                     s.PROCESS_NAME,
 11                     s.FAILURES,
 12                     sysdate, 
 13                     s.LAST_ERROR_MSG 
 14             FROM    DBA_QUEUE_SCHEDULES s, 
 15                     DBA_PROPAGATION p
 16             WHERE   p.DESTINATION_DBLINK = s.DESTINATION
 17             AND     s.SCHEMA = p.SOURCE_QUEUE_OWNER
 18             AND     s.QNAME = p.SOURCE_QUEUE_NAME
 19             AND     (s.SCHEDULE_DISABLED='Y'
 20             OR      s.START_DATE > sysdate 
 21             OR      PROCESS_NAME is not null
 22             OR      s.FAILURES > 0
 23             OR      ERROR_MESSAGE is not null
 24             OR      LAST_ERROR_MSG is not null);

no rows selected
Re: ORA-00904: [message #355006 is a reply to message #355002] Wed, 22 October 2008 03:46 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Actually i also tested this thing on my other database and on there it is working fine.

But on the current database it is showing this error Sad
Re: ORA-00904: [message #355008 is a reply to message #355002] Wed, 22 October 2008 03:49 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
My best guess will be you are missing grants to this package. Try to do a describe of this package DBMS_LOGREP_UTIL on both the schema/database.

Regards

Raj

[Edit:] Added package name

[Updated on: Wed, 22 October 2008 03:50]

Report message to a moderator

Re: ORA-00904: [message #355009 is a reply to message #355006] Wed, 22 October 2008 03:49 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have you checked for invalid objects in the SYS and SYSTEM schemas?
Re: ORA-00904: [message #355011 is a reply to message #355009] Wed, 22 October 2008 03:53 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Don't you think if an object is invalid oracle will try to recompile it when it is referred and if unsuccessful it will throw an exception ? However for some reason I am not able to find this package in the oracle reference manual.

Regards

Raj

[Updated on: Wed, 22 October 2008 03:54]

Report message to a moderator

Previous Topic: select into a variable problem
Next Topic: problem using utl_file.fgetattr in reports
Goto Forum:
  


Current Time: Mon Nov 04 12:54:17 CST 2024