Set Session mode inside Stored procedure in Teradata
<p>While running this procedure, </p>

<pre><code>CREATE PROCEDURE SP_DISABLE_TRIGGER(
in p_database varchar(50), in p_trigger_name varchar(50))
BEGIN
DECLARE L_SQL VARCHAR(1000);    


set l_sql='alter trigger ' ||p_database|| '.' ||p_trigger_name|| ' DISABLED';
EXECUTE IMMEDIATE L_SQL;   

commit;    END;
</code></pre>

<p>I'm getting this error:</p>

<blockquote>
  <p>SPL1027:E(L30), Missing/Invalid SQL statement'E(5510):Invalid session mode for procedure execution.'.</p>
</blockquote>

<p>[Executed: 1/3/2016 3:50:30 PM] [Execution: 0ms]</p>

<p>Can anyone tell me how to set the session mode inside procedure?</p>