Re: What is in a pipe?
Date: Thu, 29 Jan 2009 06:33:56 -0800 (PST)
Message-ID: <1a01fb15-db69-4b6b-aa97-9052eef860f4_at_g39g2000pri.googlegroups.com>
On Jan 28, 5:46 pm, K Gopalakrishnan <kaygo..._at_gmail.com> wrote:
> Geoff,
>
> How about checking V$db_pipes?
> It does have the pipe_name and type (public/private).
>
> -Gopal
But it basically stops there, and does not provide the information the OP requested. It's likely the OP will need to 'roll his own' utility or methodology by creating a table to contain the desired data then populating that table with each call to dbms_pipe.pack_message. This, then, creates a possible maintenance nightmare as every call to dbms_pipe.unpack_message would require a delete from this same table for the record matching the unpacked pipe messge. Absent that consideration the OP could then query his home-grown table to find, at any moment, the expected contents of the desired pipe (given, of course, that all of the inserts succeeded and none of the deletes failed).
David Fitzjarrell Received on Thu Jan 29 2009 - 08:33:56 CST