#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2016
    Posts
    1
    Rep Power
    0

    Cool Context NEW & OLD to stored procedure


    Hi,

    i have a problem! Is it possible to set the context-varaible NEW and OLD from a trigger to a stored procedure?


    Code:
    CREATE OR ALTER trigger PEM_MDL_AIU0_LIC_CHECK for PEM_MODULE
    active after insert or update position 0
    as
    begin
      execute procedure SP_UPDATE_USER(new, old);
    end

    i had googled much things, but no result found!!!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    242
    Rep Power
    17
    In the way you want to do it - no, you can't. You can pass different fields' values as parameters like - EXECUTE PROCEDURE SP_UPDATE(OLD.ID, OLD.NAME, NEW.ID, NEW.COUNTER)

IMN logo majestic logo threadwatch logo seochat tools logo