Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unhappy Unanswered: character set name is not recognized in Trigger

    Hello,

    I'm trying to recompile some triggers, but I get the error:

    TRIGGER GCTICSADMINISTRATOR.EMAILIN_BR_D
    On line: 8
    PLS-00553: character set name is not recognized

    This is because it doesn't recocnize the ld.id. I had this with several others and when I drop and recreate the table everything works ok. (I copy the script from the existing table including the trigger.)

    Unfortunately I can't do this for all the tables because some have data in them. Does someone know what the real problem is?

    The actual script is below:

    <<CREATE OR REPLACE TRIGGER "GCTICSADMINISTRATOR".emailin_br_d
    before delete
    on emailin
    for each row
    declare
    test number;
    begin

    select count(*)
    into test
    from deleted_interaction
    where objectid=ld.id;

    if test = 0 then
    insert into deleted_interaction
    (objectclassname,
    objectid,
    threadid,
    subthreadid)
    values ( 'emailin', ld.id, 0, 0 );
    end if;
    end;
    >>

    thanks for your help in advance.

  2. #2
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60

    Red face

    What do you mean by

    *ld.id

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    This should have been :NEW.id

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •