USP_LUMINATEONLINEDATACONNECTOREXCEPTION_ADD

Parameters

Parameter Parameter Type Mode Description
@LUMINATEONLINEDATACONNECTORID uniqueidentifier IN
@EXCEPTIONMESSAGE nvarchar(1000) IN
@STACKTRACE nvarchar(2000) IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


create procedure dbo.USP_LUMINATEONLINEDATACONNECTOREXCEPTION_ADD (
  @LUMINATEONLINEDATACONNECTORID uniqueidentifier,
  @EXCEPTIONMESSAGE nvarchar(1000),
  @STACKTRACE nvarchar(2000),
  @CHANGEAGENTID uniqueidentifier
)
as
begin
  set nocount on;

  if @CHANGEAGENTID is null  
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    insert into dbo.LUMINATEONLINEDATACONNECTOREXCEPTION (
    ID,
    LUMINATEONLINEDATACONNECTORID,
    EXCEPTIONMESSAGE,
    STACKTRACE,
    ADDEDBYID,
    CHANGEDBYID
  ) values (
    newid(),
    @LUMINATEONLINEDATACONNECTORID,
    @EXCEPTIONMESSAGE,
    @STACKTRACE,
    @CHANGEAGENTID,
    @CHANGEAGENTID
  );

  return 0;
end