Skip to Main Content

SQL & PL/SQL

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!

Synonym Problem

235703Jan 22 2003 — edited Jan 23 2003
Hi,

I have two schemas AQUSER and INT.

In AQUSER I have an
Oracle Queue: MAIN_QUEUE
Queue table : MAIN_QTAB (Queue table is created using the type MAIN_MSG_TYPE)

I have triggers in INT schema and I need to use these queue in AQUSER schema. In the trigger code I create a instance of this object type MAIN_MSG_TYPE. But I have to use the schema name too, as-

declare
l_message aquser.MAIN_MSG_TYPE;
begin
.
.
.

Inspite of creating a public synonym for MAIN_MSG_TYPE I still need to use the schema name to access the MAIN_MSG_TYPE (the synonym does not work).

Are synonym allowed for a TYPE object. If yes, is there something I'm missing because of which I'm not able to use the synonym for the TYPE.

Regards,
Milton.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2003
Added on Jan 22 2003
3 comments
214 views