Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1A

SYMPTOM(s):

SQL-92: Error (10713) creating an SQL-92 UPDATE event java trigger.

Syntax error at or about (statement excerpt). (10713)

SQLState: HY000
Message: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "(Custnum, City, State, Country, " (10713)
VendorCode: -210056

Executing code similar to:
CREATE TRIGGER PUB.UpdateCustomer
AFTER UPDATE OF (Custnum, City, State, Country, PostalCode, Balance)
ON PUB.Customer
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.Date ;
import java.math.BigDecimal ;
BEGIN
/* Other code goes here */
END

SQL trace file info includes:
sqlcode = -210056, SQLSTATE = 42700
Syntax error in SQL statement at or about "(Custnum, City, State, Country, " (10713)

CAUSE:

The column list after the OF option should no longer be parenthesized. In 9.1x, the parenthesis was a requirement for this column list. In 10.x it is not allowed.

FIX:

Remove the parenthesis around the column list following the OF option:
CREATE TRIGGER PUB.UpdateCustomer
AFTER UPDATE OF Custnum, City, State, Country, PostalCode, Balance
ON PUB.Customer
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.Date ;
import java.math.BigDecimal ;
BEGIN
/* Other code goes here */
END