Kbase P8406: Error 8184 Calling SQL-92 Stored Procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error 8184 when executing SQL-92 Stored Procedure
Character string is too long (8184)
The Stored Procedure compiles fine
Error occurs calling the Stored Procedure
CAUSE:
At runtime, if a value greater than the Variable's length gets assigned to a variable, the error 8184 is returned
FIX:
Make sure to not assigning Values longer than the length of a Variable.
After making the change, drop and recompile the Stored Procedure before calling it again.