Kbase 20837: Error 2303 running stored-procedures with Dataserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL Server
ODBC DataServer
Oracle DataServer
SYMPTOM(s):
More than one active handle -- no default (2303)
Error occurs when running an application containing RUN STORED-PROC statement
Multiple stored procedures are being run
CAUSE:
The DataServer sets a handle for each time a stored-procedure runs though 4GL.
If more than one stored-procedure is running at a time, error 2303 occurs under the following conditions:
1. Handle is not specified within a stored-procedure statement
2. There are more than one active stored-procedures. The stored-procedure is active until the CLOSE STORED-PROC statement is executed.
FIX:
Reference the appropriate handle for each stored-procedure in the following statements.
RUN STORED-PROC
FOR EACH proc-text-buffer (or your buffer name)
CLOSE STORED-PROC