Store Procedure with special characters

General Discussion
1

Glad you got it. < would work as a replacement for < too.  The joy of XML…


Nathan

2

Dear all,

I am new to liquibase and trying to use it in my current project. At this moment, I need to create a stored procedure and this is the code

  1.       CREATE PROCEDURE MVLOG(IN period INT)
  2.     BEGIN
  3.         INSERT INTO dblog_archive
  4.             SELECT * FROM dblog
  5.             WHERE log_date < DATE_SUB(CURRENT_DATE(), INTERVAL period DAY);
  6.         DELETE FROM dblog
  7.             WHERE log_date < DATE_SUB(CURRENT_DATE(), INTERVAL period DAY);
  8.     END;


Obviously, if i put it into the tag, it will make error during parsing xml since the “<” in the procedure code. How can i overcome this issue ?

3

nevermind. CDATA do the trick. I am an idiot :frowning: