Hi Everyone,
I tried to create the first procedure in Progress database but I had some compile errors. Anyone see any problem with the most simple procedure we can write?
// My procedure
CREATE PROCEDURE erp.Test01()
BEGIN
String message ="Hello World";
END
// Errors
CREATE PROCEDURE erp.Test01()
BEGIN
String message ="Hello World";
13:01:39 [CREATE - 0 row(s), 0.000 secs] [Error Code: -210056, SQL State: S1000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about " String message ="Hello World"" (10713)
END;
13:01:39 [END - 0 row(s), 0.000 secs] [Error Code: -210056, SQL State: S1000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "END" (10713)
... 2 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 2 errors]
regards,
Jdang
I have the same problem. Why can not compile the simplest procedures?
Error:
[DataDirect]OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "END" (10713)
I use OpenEdge Architect.
EDIT:
I have found the following:
http://communities.progress.com/pcom/servlet/JiveServlet/download/10355-3-9823/oe_101c_readme.pdf
It describes my problem. But is not the solution. I've tried it, but it did not work.
You may have another idea?
Hello,
The syntax error happens because the SQL editor uses ";" as a separator.
This issue can be resolved by changing the "SQL editor separator" to a different value in the Preferences page (Window/Preferences/Progress DB Navigator). For example, "|" could be used instead.