Kbase P87463: Is it possible to run an Oracle stored procedure from a Progress session and continue control withou
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/09/2004 |
|
Status: Unverified
GOAL:
When running an Oracle Stored procedure from a Progress session, is it possible to keep control without waiting for the result set
GOAL:
Is it possible to get the control back when the Oracle stored procedure hangs
FACT(s) (Environment):
Oracle
FACT(s) (Environment):
Oracle DataServer
FIX:
No it is not possible.
When the RUN STORED-PROC is executed, the OCI to execute the stored procedure is called by Progress.
Later, when the FOR EACH is executed to get the result set back, the data is fetched.
If the execution hangs for a while waiting for the connection to the Oracle database, then there is no way to stop it and continue control until Progress gets control back after the OCI call is executed.