Kbase P46026: How to handle errors in sql-92 triggers and stored procedures?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2005 |
|
Status: Unverified
GOAL:
How to handle errors in sql-92 triggers and stored procedures?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
Progress SQL-92 provides the DhSQLException class so procedures can process and generate Java exceptions through the try, catch, and throw constructs. Use the DhSQLException class to get the exception and the log method to log the error which will show up in a *.trc file.