My DB is ORACLE.
I plan to create a procedure through LIQUIBASE.
But, When I write some SQL like below
…
…
if(X >= Y) then
Z := 1;
end if;
…
…
I run it through CMD.
CMD show me some errors because of sign “>” is invaild.
My DB is ORACLE.
I plan to create a procedure through LIQUIBASE.
But, When I write some SQL like below
…
…
if(X >= Y) then
Z := 1;
end if;
…
…
I run it through CMD.
CMD show me some errors because of sign “>” is invaild.
This is XML and “>” has to be escaped using “>”
…
if(X >= Y) then…
You can also use a CDATA block too, depending on what works better for you.
Nathan
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Imbedded & and tag characters (<) in data in sql statement | 7 | 14703 | June 11, 2009 | |
| <> > < symbols not working in liquibase XML format | 3 | 4101 | January 18, 2021 | |
| SQL <= operator messes up xml | 3 | 2943 | September 14, 2021 | |
| RESOLVED - Stored Procedure escape characters? | 2 | 1457 | April 12, 2012 | |
| The processing instruction target matching "[xX][mM][lL]" is not allowed. | 6 | 2110 | November 8, 2011 |