Kbase P25635: Error 5196 when the SELECT's in stored procedures return no
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/07/2003 |
|
Status: Verified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
MS SQL 2000
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 5196 when the SELECT's in stored procedures return no records.
Record returned from fdfnd is too large; size= <size> (5196)
SELECT is the only statement in the stored procedure.If there's anything else before the SELECT, there's no error with the empty result set.
Stored procedures that return an error message if no row is found are ok.
Use closeall instead of close stored-proc is OK
CAUSE:
Bug 20030422-022
FIX:
This issue as been fixed in 9.1D06 (Progress v9 SP6)
You could use the next possible workarounds to the bug in previous releases:
1. Use send-sql-statement to have the same select function
2. Add some other statements before select
3. Return an error when no row is selected