I'm trying to connect to an Oracle queue using C#.
I'm using the Oracle.DataAccess.Client DLL:
OracleAQQueue queue = new OracleAQQueue("BANINST1.GP_SYNC_Q", connection, OracleAQMessageType.Udt, "BANINST1.GP_SYNC_Q");
Where BANINST1 is obviously the schema and GP_SYNC_Q is the queue name. The DB connection is established, as I can run SQL using the connection object.
But I keep getting the following error when I run queue.Dequeue():
OCI-22303: type "BANINST1"."GP_SYNC_Q" not found
I can't seem to get past this. I've confirmed that the permissions are correct. The user has both Queue and Dequeue privileges. Any ideas on this? Much appreciated!