I am using the listings environment to display some SQL statements. Some of these contain signal statements which print out messages. The problem is, that the message output is diplayed like_this_for_all_messages... So I need a way to display normal text within the listings enviornment. Any ideas?
Code: Select all
\begin{lstlisting}[frame=tb, language = SQL, title={Trigger on update of QUESTIONNAIRE}]
CREATE TRIGGER QUESTIONNAIRE_STATE_UPDATE
AFTER UPDATE OF WORKFLOW_STATE ON QUESTIONNAIRE
REFERENCING NEW AS N OLD AS O
FOR EACH ROW
BEGIN ATOMIC
DECLARE CHECK_QUESTIONNAIRE_ID INTEGER;
SET CHECK_QUESTIONNAIRE_ID = N.QUESTIONNAIRE_ID;
IF (EXISTS(SELECT STATE FROM RULE_VIOLATION, QUESTIONNAIRE
WHERE RULE_VIOLATION.QUESTIONNAIRE_ID = CHECK_QUESTIONNAIRE_ID AND STATE = 1 OR STATE = 3
AND N.WORKFLOW_STATE > 0))
THEN SIGNAL SQLSTATE '90000'
SET MESSAGE_TEXT ='Questionnaire contains rule violations in data entries. Please revise questionnaire.';
END IF;
END @
\end{lstlisting}