Kbase P83269: SQL-92: Error (8184) when executing CREATE TRIGGER Statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Error (8184) when executing CREATE TRIGGER Statement.
SQLState=HY000
ErrorCode=-20152
[JDBC Progress Driver]:Character string is too long (8184)
CAUSE:
The CREATE TRIGGER Statement does not follow the required syntax.
FIX:
Verify that the syntax is correct.
CREATE TRIGGER [ owner_name.]trigname
{ BEFORE | AFTER }
{ INSERT | DELETE | UPDATE [ OF column_name [ , ... ] }
ON table_name
[ REFERENCING { OLDROW [ ,NEWROW ] | NEWROW [ ,OLDROW ] } ]
[ FOR EACH { ROW | STATEMENT } ]
[ IMPORT
java_import_clause ]
BEGIN
java_snippet
END
Reference to 'SQL-92 Guide and Reference', Create Trigger statement (3-29)