Re: Viewing LCR Contents in Streams Capture Queues
Date: Mon, 8 Dec 2008 16:54:28 -0500
As I see it, procedure print_lcr just prints any sys.anydata chunk assuming it's LCR generated by streams capture. I responded to Stuart privately, stating that - if there is a need to examine LCR in capture queue I don't see why we cannot create custom subscriber to it with positive rule set to filter all LCR of interest and in dequeue routine execute modified print_lcr procedure to capture the output.
Also I wanted to second Alex's question - why do you want to see that ?
On Mon, Dec 8, 2008 at 4:35 PM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:
> This procedure print contents of the LCRs in the error queue so you
> understand why the error has happened and how to fix it.
> It doesn't work really well in case you have a lot of messages (since
> it prints everything in the LCR, not only what causes an error) but
> that's easily modifiable to avoid.
> I don't think there is anything which can allow you to see in-flight
> LCRs in the buffered queue so let me rewrite the question. Why do you
> want to see these?
> On Mon, Dec 8, 2008 at 3:41 PM, Roman Podshivalov
> <roman.podshivalov_at_gmail.com> wrote:
> > Hi,
> > If you can get LCR from capture queue it can be printed out by using the
> > procedure from 10G documentation. However I've never tried it personally.
> > --romas
> > On Mon, Dec 8, 2008 at 3:05 PM, Stuart Blackburn <sblackbu_at_cbnco.com>
> >> Does anyone know how to view the contents of an LCR that is currently
> >> sitting in a Streams buffered capture queue?
> >> DBMS_APPLY_ADM.GET_ERROR_MESSAGE is helpful for displaying the contents
> >> an LCR if it produces an apply error, but I can't find anything similar
> >> LCR's sitting in a buffered queue. Thanks.
> >> Stuart
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> Alex Fatkulin,