Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name NON_PERSISTENT_QUEUE
Short Name NPQ
View NameCI_NON_PERSISTENT_QUEUES
Description A non-persistent Oracle queue is a repository for messages, only
allowing the sending of messages to subscribers and explicity
specified recipients who are local
Sub-type of QUEUE
Versioning: Structure of NON_PERSISTENT_QUEUE versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: NAME
Used by: Oracle Designer

Underlying table:SDD_QUE

Reference Properties
Name Opt ? Notes Relationship In Arc

Properties
Name Datatype Opt ? Notes Domain Default Value
MULTIPLE_CONSUMERS_FLAG VARCHAR2(1) N Indicates whether used by single or multiple consumers. A value of "Default" indicates the database default should be used
Prompt: Multiple Consumers ?
Uppercase
YESNODEF D
NAME VARCHAR2(30) N Name of the queue
Prompt: Name
Uppercase
Defined on QUE supertype
QUEUE_SUBTYPE VARCHAR2(3) N Sub-type discriminator. Internal system maintained property indicating the QUEUE subtype
Not displayed
Uppercase
System maintained
Not updatable by user
Defined on QUE supertype
QUEUE_SUBTYPE
REMARK VARCHAR2(2000) Y A brief comment about this queue
Prompt: Comment
Defined on QUE supertype

Multi-line Text
Name Text Type Prompt
DESCRIPTION CDIDSC
Defined on QUE supertype
Description
HELP CDHELP
Defined on QUE supertype
User/Help Text
NOTES CDINOT
Defined on QUE supertype
Notes

Other Properties
NON_PERSISTENT_QUEUE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types:
  • ID
  • IRID
  • IVID
  • ELEMENT_TYPE_NAME
  • DATE_CREATED
  • CREATED_BY
  • DATE_CHANGED
  • CHANGED_BY
  • NUMBER_OF_TIMES_MODIFIED
  • TYPES

Other element types that reference NON_PERSISTENT_QUEUE:


Note:

  • All properties are displayed and updatable by the user unless indicated otherwise
  • All reference properties are displayed and transferable unless indicated otherwise
  • All domains are enforced unless indicated otherwise
  • All properties and reference properties are defined on this element type unless indicated as inherited from a supertype