Re: Viewing LCR Contents in Streams Capture Queues

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.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_apmon.htm#CHDCBCIC
>
> --romas
>
> On Mon, Dec 8, 2008 at 3:05 PM, Stuart Blackburn <sblackbu_at_cbnco.com> wrote:
>>
>> 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 of
>> an LCR if it produces an apply error, but I can't find anything similar for
>> LCR's sitting in a buffered queue. Thanks.
>>
>> Stuart
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>
>

-- 
Alex Fatkulin,
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l