Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Problems connecting to Oracle queue using C#

User_QLGOS
Member Posts: 1 Green Ribbon
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!