Kbase 33254: Escape clause beginning with --*( or { was not properly ended with *)-- or}:
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P3254
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.1B
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
Compiling Java Stored Procedure or Java Trigger fails
The try catch block contains more than 10 lines of code
Error Escape clause beginning with --*( or { was not properly ended with *)-- or}:
Example: the following code returns the error when compiling:
CREATE TRIGGER PF_AUTONUMBER
AFTER UPDATE ON pub.OCTOBJECTSINDEXES
REFERENCING OLDROW, NEWROW
FOR EACH ROW
IMPORT
import java.sql.*;
BEGIN
try
{
String test1;
String test2;
String test3;
String test4;
String test5;
String test6;
String test7;
String test8;
String test9;
String test10;
String test11;
} catch (Exception e){}
END;
CAUSE:
This is a known issue for try catch blocks that contain more than 10 lines.
FIX:
Make sure that your try catch block has 10 lines or less of code. The procedure or trigger should then compile without the error.
Example :
CREATE TRIGGER PF_AUTONUMBER
AFTER UPDATE ON pub.OCTOBJECTSINDEXES
REFERENCING OLDROW, NEWROW
FOR EACH ROW
IMPORT
import java.sql.*;
BEGIN
try
{
String test1;
String test2;
String test3;
String test4;
String test5;
String test6;
String test7;
String test8;
String test9;
String test10;
} catch (Exception e){}
END;