Kbase P18372: Stored procedure disappears after closing a session
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/01/2003 |
|
Status: Unverified
SYMPTOM(s):
Close a session
Stored procedure disappears
CAUSE:
The COMMIT; command needs to be added at the end of the code. Otherwise, the procedure is available only for the current session.
FIX:
The COMMIT; statement commits the procedure (saves it) to the database.