Home » Server Options » Streams & AQ » DML / DDL Handlers (11gr2)
DML / DDL Handlers [message #482205] Wed, 10 November 2010 05:39 Go to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member

I want to create DDL/DML handlers for my existing Globle streaming process. I do not have knowledge in this respect. Can you please provide me some URL's, to learn creating and deploying such handlers.


Thanks in advance.
Re: DML / DDL Handlers [message #482233 is a reply to message #482205] Wed, 10 November 2010 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you have a look at books at http://www.oracle.com/pls/db112/portal.all_books#index-STR?

I think the 4th one (Streams Extended Examples) will give you what you need.
Of course you have to know to program in PL/SQL.

Regards
Michel

[Updated on: Wed, 10 November 2010 08:47]

Report message to a moderator

Re: DML / DDL Handlers [message #482420 is a reply to message #482233] Thu, 11 November 2010 06:18 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
I could not find working examples of creating DML / DDL Handlers for Oracle Streams. Can you please point some specific meterial.
Re: DML / DDL Handlers [message #482422 is a reply to message #482420] Thu, 11 November 2010 06:32 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search in 9i documentation, I'm sure there are some as I used them.
http://tahiti.oracle.com

Regards
Michel
Previous Topic: Error creating Streams example - ORA-01729: database link name expected
Next Topic: Supplemental logs
Goto Forum:
  


Current Time: Thu Mar 28 06:37:44 CDT 2024