Hi,

Is there anybody who has done data transformation using Advanced queues or streams.
Our main concerns:
Is it possible to transform and transmit data using streams for example table to table (bi dirctional) having different structure or may be different data type (ex: char to date or numbr to date) if yes then how to transform data because we have seen many documents where they talk about creating a object type or some pictorial representations but nowhere we got proper info.

If any boby having expertise on this please help us.

regards

Satya

Check out my blog here:

http://www.oraclealchemist.com/oracle/make...y-with-streams/

The second set of commands show an example LCR handler, which is a PL/SQL program that works with the ANYDATA LCR and can be used to perform data transformations.

You can use Streams aq_adm to map individual columns, even from non-matching tables and diverse data stores. The only requirement is that the sender and target columns "match" datatypes.

For working examples, Madhu Tuma describes this process in the Oracle Streams book.

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