Re: streams insert - update - commit error handler

Hi,

What kind of supplemental logging you have turned on for DIALCODES table ? As you can see in the trace some values are reported as "no available value" for where clause of your update:

knipdmpargs: dump new argument list:

   column: "DCID"

             no available value
   column: "DCIDPARENT"

             no available value
   column: "DCTEXT"

             no available value
   column: "DCTYPE"

           (dty, kncdty, acl, csf, csi, ind)=(1,0,3,1,31,0)
value =             XXX
   column: "DCVALIDFROM"
             no available value
   column: "DCVALIDTO"
             no available value
   column: "DCVALUE"
             no available value

As of creating the band aid solution with an error handler - I personally think you gotta just configure streams correctly and do not reinvent the bicycle 8-)

--romas

On Mon, Sep 15, 2008 at 9:18 AM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com>wrote:

> lists,
>
> I have tested streams on very simple configuration, which consist of
> source and destination database.
> for all simple transactions there are no serious conflict/error, but
> with this kind of transaction, the apply process become stuck :)
>

--
http://www.freelists.org/webpage/oracle-l