stored-procedures - Informix 12.10 当语句无法从查询中“准备”时查找查询中的错误点

Question

我在程序中有这样长的查询

 CREATE PROCEDURE procedure1(var type1)
 DEFINE Result   Type2;
 LET c_query =
 "SELECT "      || 
 "RESULT "      || 
 "FROM "        ||
 "QUERY_PART1 " ||
 "join "        ||
 "QUERY_PART2 " ||
 "join "        ||
 ...
 "END_PART ";

 PREPARE c_stmt FROM c_query; --  Problematic line

 DECLARE c_cur CURSOR FOR c_stmt;
 OPEN c_cur;
 ....
 END  PROCEDURE

但是“PREPARE c_stmt FROM c_query;” 行不运行，错误是

Execute: A syntax error has occurred

我尝试在线查找查询的语法错误，但没有奏效。我可以找到错误行吗？

有人可以帮忙吗？

标签： stored-proceduresinformix