sir,
I want to know whether is it possible to send CLOB data automatically using CDC...i usually have to run a procedure manually to send such data to remote locations...so is it possible ??

its really urgent sir...

Hi Vipul,

>> its really urgent sir...

How can this be urgent? Is a production database down? Are people lives at stake?

Vipul, in life-or-death urgent matters, you need to post with Oracle, not in a forum!!

Call 800-223-1711 immediately and open a severity 1 service request.

***************************************
>> I want to know whether is it possible to send CLOB data automatically using CDC

Yes, CDC supports CLOBS:

http://docs.oracle.com/cd/E11882_01/server...rms_capture.htm

Also see a working example of using CDC with a CLOB here:

http://www.dba-oracle.com/t_cdc_clob.htm

To download a checklist to configure Streams get the book "Oracle Streams":

http://www.rampant-books.com/book_0402_streams.htm