Skip to content

cannot get DLL for object type QUEUE #25

@GoogleCodeExporter

Description

@GoogleCodeExporter
What steps will reproduce the problem?
I execute the command line jar file to process an Oracle database schema with 
objects of type QUEUE.

What is the expected output? What do you see instead?
I see the error message ORA-31600 : invalid input value QUEUE for parameter 
OBJECT_TYPE in function GET_DDL.  I tested the GET_DDL oracle function in SQL 
DEVELOPER and sure enough QUEUE is an invalid object type input parameter.  I 
googled for valid Oracle object types for GET_DDL and found two object types 
that are related to the queue type. AQ_QUEUE(for queues) and AQ_QUEUE_TABLE(for 
table queues).  I am not sure how to determine queue type to help you fix this. 
 I am new to Oracle. 

What version of the product are you using? On what operating system?
Oracle 11g 11.2.0.3.0 - 64 bit, Windows Server 2008 R2 Standard


Original issue reported on code.google.com by [email protected] on 2 Oct 2014 at 9:14

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions