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

    Unanswered: not all variables bound(Distributed Database)

    I have an after update row level trigger in local database which updates the relevant table in remote database.But when i try to update table in local database i get following error
    ORA-01008: not all variables bound
    ORA-02063: preceding line from SITETOP3E
    ORA-06512: at "<<schema_name>>.<<trigger_name>>", line 3
    ORA-04088: error during execution of trigger
    '<<schema_name>>.<<trigger_name>>'

    Can anybody tell what could be the reason and workaround for it?
    Thks

  2. #2
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: not all variables bound(Distributed Database)

    Post the trigger.

    Originally posted by keyur76
    I have an after update row level trigger in local database which updates the relevant table in remote database.But when i try to update table in local database i get following error
    ORA-01008: not all variables bound
    ORA-02063: preceding line from SITETOP3E
    ORA-06512: at "<<schema_name>>.<<trigger_name>>", line 3
    ORA-04088: error during execution of trigger
    '<<schema_name>>.<<trigger_name>>'

    Can anybody tell what could be the reason and workaround for it?
    Thks

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Re: not all variables bound(Distributed Database)

    Originally posted by sjacek
    Post the trigger.
    CREATE OR REPLACE TRIGGER t1
    AFTER DELETE OR UPDATE ON PRIME_ACTIVITY_MASTER
    FOR EACH ROW
    BEGIN
    IF UPDATING THEN
    UPDATE ACTVCODE SET SHORT_NAME = :NEW.PA_SHORT_NAME ,
    ACTV_CODE_NAME = :NEW.WORK_TYPE_NAME
    WHERE ACTV_CODE_ID IN
    ( SELECT ACTV_CODE_ID FROM TEMP_ACTVCODE
    WHERE WORK_TYPE_ID = :NEW.WORK_TYPE_ID);
    END IF;

    IF DELETING THEN
    DELETE FROM ACTVCODE
    WHERE ACTV_CODE_ID IN
    ( SELECT ACTV_CODE_ID FROM TEMP_ACTVCODE
    WHERE WORK_TYPE_ID = :OLD.WORK_TYPE_ID);

    DELETE FROM TEMP_ACTVCODE
    WHERE WORK_TYPE_ID = :OLD.WORK_TYPE_ID ;
    END IF;
    END;
    /

    ACTVCODE is table in Remote Database(8i)
    PRIME_ACTIVITY_MASTER is table in local Database(9i)

    Thks

Posting Permissions

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