Kbase P100169: Is it possible to close an Oracle cursor?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Is it possible to close an Oracle cursor?
GOAL:
What 4GL statement allows to close an Oracle cursor?
FACT(s) (Environment):
Oracle DataServer
FIX:
Enhancement Request Id# 00000028 has been logged. There is no 4GL statement to close the Oracle cursors yet.
By issuing enough new 4GL statements so that different Oracle cursors will be needed is a way to have the DataServer closing earlier Oracle cursors. The total number of cursors for your Oracle connection is defined by the startup parameter "-c"; the default value for "-c" is 50 unless Oracle OPEN_CURSORS parameter is set to a lower value.