Trigger problems with CONCAT

I have a trigger that runs when records are inserted in my table. Currently, it works fine. The table INKTOMI_CATALOG has the following rows CT_PRODNUM, CT_FORM, CT_DOCTYPE, CT_TITLE, CT_X, CT_Y, CT_DATE, CT_SUFFIX
Here is the trigger:

TRIGGER VIGNETTE.TGR_INS_INKTOMI_CATALOG AFTER     INSERT
    ON "INKTOMI_CATALOG"
BEGIN
UPDATE INKTOMI_CATALOG

SET CT_SUFFIX = SUBSTR(CT_PRODNUM, LENGTH(CT_PRODNUM), 1),
    CT_DOCTYPE = SUBSTR(CT_DOCTYPE, 1, 4),
    CT_DATE = SYSDATE

    INSERT
    ON "INKTOMI_CATALOG"
BEGIN
UPDATE INKTOMI_CATALOG

SET CT_SUFFIX = SUBSTR(CT_PRODNUM, LENGTH(CT_PRODNUM), 1),
    CT_DOCTYPE = SUBSTR(CT_DOCTYPE, 1, 4),
    CT_TITLE = SUBSTR(CT_DOCTYPE, 1, 4) || ' ' || CT_TITLE,
    CT_DATE = SYSDATE

Thie problem is that it seems to get stuck in sort of look when it runs. In the first record, the value for CT_DOCTYPE is "Form" and the value for CT_TITLE is "Form Form Form Form Form Form Form Form Form Form Form Form Form Form U.S. Individual ....." (the original value of CT_TITLE is "U.S. Individual ....."

I am stuck, I can't figure out what the problem is. All help is appreciated. Received on Wed Mar 13 2002 - 19:05:24 CET