I'm writing a program to dequeue messages. The queue, tables and types reside in a different schema, but the user id I'm using has access to everything.
When I specify the the parms like so:
oracleQueue.PayloadTypeName = "aqadmin.tick_msg_type";
oracleQueue.QueueName = "aqadmin.tick_queue";
I get an error stating: "OCI-22303: type ""."TICK_MSG_TYPE" not found"
It seems to be dropping the schema.
If I use the schema owner it works fine. I have tested using pl/sql and it works fine.
Queues and schema's
-
- Posts: 43
- Joined: Thu 19 Jun 2008 14:30
-
- Posts: 43
- Joined: Thu 19 Jun 2008 14:30