Kbase P135184: Error 10713 when compiling Java stored procedure or trigger in OpenEdge Architect SQL Editor
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/11/2010 |
|
Status: Verified
SYMPTOM(s):
Error 10713 when compiling Java stored procedure or trigger in OpenEdge Architect SQL Editor
Syntax error at or about (statement excerpt). (10713)
Syntax error at or about "END" (10713)
FACT(s) (Environment):
Java statements end with semicolons.
SQL editor separator in DB Navigator preferences is a semicolon (the default value).
Windows
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
Java code is being interpreted as SQL code.
FIX:
Change the SQL editor separator to a different value when compiling Java stored procedures or triggers. From the OpenEdge Architect main menu, choose Window > Preferences. From the Preferences dialog, choose Progress DB Navigator (10.1C) or DB Navigator (10.1B). Change the SQL editor separator to something other than a semicolon and click OK.