PROBLEM:
An error is returned when running the ant script to create the CRC Stored Procedures. Upon further investigation it appears the problem is with the create statement in the CREATE_TEMP_PROVIDER_TABLE.sql script. The following statements are excerpts from the error received when running this script.


ERROR MESSAGE (EXCERPTS):

Failed to execute:
CREATE OR REPLACE FUNCTION create_temp_provider_table (tempProviderTableName IN text,
    errorMsg OUT text)
RETURNS
CREATE_TEMP_PROVIDER_TABLE.sql
text AS $body$
. . .
Org.postgresql.util.PSQLException: ERROR: syntax error at or near "text"
     Position: 152



RECOMMENDED SOLUTION:

Remove the reference to CREATE_TEMP_PROVIDER_TABLE.sql in the script. The edited version would be as follows:

CREATE OR REPLACE FUNCTION create_temp_provider_table (tempProviderTableName IN text,
    errorMsg OUT text)
RETURNS text AS $body$
. . . the rest of the script