Synonym Problem
235703Jan 22 2003 — edited Jan 23 2003Hi,
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.