Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synonyms on Queue Tables and Queues

183703Feb 15 2008 — edited Feb 26 2008
The Queue is owned by ctest_owner. When i execute the update statement, the trigger fires the queue. This is working when i execute the statement as ctest_owner. But fails when i execute as application user. I believe i am missing either a privilege or synonym.

SQLL> connect ctest_app@dev
Connected.
SQL> update test
2 set start_date = start_date + 1/24
3 where test_id = 87 ;
update test
*
ERROR at line 1:
ORA-25205: the QUEUE CTEST_APP.TEST_QUE does not exist
ORA-06512: at "SYS.DBMS_AQ", line 168
ORA-06512: at "CTEST_OWNER.ENQUEUE", line 14
ORA-06512: at "CTEST_OWNER.TRG_ASSET_AU", line 5
ORA-04088: error during execution of trigger 'CTEST_OWNER.TRG_ASSET_AU'

This Queue does not reside in this schema. Do i need to create a synonym for this object?

ORA-25205: the QUEUE CTEST_APP.TEST_QUE does not exist

Thanks
-Prasad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2008
Added on Feb 15 2008
2 comments
3,897 views