And what if I use the MultipleLinesSqlCommandExtractor in conjunction with CREATE FUNCTION statements to store PL/SQL-Functions? I get an "unterminated dollar-quoted string"-error while trying to load this dummy-PostgreSQL-function for example:
CREATE OR REPLACE FUNCTION dummyfunc(value integer)
RETURNS integer AS
$$
DECLARE
result integer;
BEGIN
result := value + value;
return result;
END;
$$ LANGUAGE plpgsql;
Using the SingleLineSqlCommandExtractor instead and removing all line-breaks works but is ugly.
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
And what if I use the MultipleLinesSqlCommandExtractor in conjunction with CREATE FUNCTION statements to store PL/SQL-Functions? I get an "unterminated dollar-quoted string"-error while trying to load this dummy-PostgreSQL-function for example:
CREATE OR REPLACE FUNCTION dummyfunc(value integer)
RETURNS integer AS
$$
DECLARE
result integer;
BEGIN
result := value + value;
return result;
END;
$$ LANGUAGE plpgsql;
Using the SingleLineSqlCommandExtractor instead and removing all line-breaks works but is ugly.