Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting queue table name

Re: Getting queue table name

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 31 Jan 2007 18:10:10 +0000
Message-ID: <INqdnfCdGv4XRV3YnZ2dnUVZ8tChnZ2d@pipex.net>


tim wrote:
> Hello
>
> I am trying to write a function which, when given a Queue Name, will
> run a select statement on the Queue Table it resides in. Is there a
> standard function in PL/SQL that can be used to get the Queue Table
> name when given the Queue name? Or is there another way I could do
> this?
>
>
> Many thanks
>
>
> Tim.
>

In addition to the comments already given it would be interesting to me to know what you are trying to achieve. It maybe that you are reinventing a wheel.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Wed Jan 31 2007 - 12:10:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US