Error 16923: Cursorfetch: Maximum length of '%s' is incompatible with that of selected column in the cursor.

Error 16923: Cursorfetch: Maximum length of '%s' is incompatible with that of selected column in the cursor.

Post by Ipek Guve » Thu, 24 Jun 1999 04:00:00



I have a cursor in a stored procedure. And the descpritions of AMT and
C_AMT fields are:
AMT NUMERIC(16, 2) in Table_1
C_AMT NUMERIC(16, 2) in Table_2


.
.
.
DECLARE CR CURSOR FOR
SELECT  CONVERT(NUMERIC(17,2), -1*AMT) FROM TABLE_1
OPEN CR


BEGIN

UPDATE TABLE_2 SET


END
CLOSE CR
DEALLOCATE CR

And I get this error :
Msg 16923, Level 16, State 1

column in the cursor.

Why does it happen? I really wonder?

 
 
 

Error 16923: Cursorfetch: Maximum length of '%s' is incompatible with that of selected column in the cursor.

Post by Neil Pik » Thu, 24 Jun 1999 04:00:00


Ipek - it's a known bug.  I guess you're using 6.5 still - this error doesn't
occur with 7.0

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp

 
 
 

1. Error: 16923 Cursorfetch: Maximum length of %s is incompatible with that of selected column in the cursor.

I have a cursor in a stored procedure. And the descpritions of AMT and
C_AMT fields are:
        AMT     NUMERIC(16, 2) in Table_1
        C_AMT   NUMERIC(16, 2) in Table_2

DECLARE

.
.
.
DECLARE CR CURSOR FOR
        SELECT  CONVERT(NUMERIC(17,2), -1*AMT) FROM TABLE_1
OPEN CR


BEGIN

        UPDATE TABLE_2 SET


END
CLOSE CR
DEALLOCATE CR

And I get this error :
Msg 16923, Level 16, State 1

column in the cursor.

Why does it happen? I really wonder?

2. select distinct

3. 'Incompatible Database Version' error

4. How do I get files in a directory into a TSQL Array?

5. Maximum length is incompatible wiht that of selected column in the cursor

6. Job Opening: Programmer Analyst

7. Access 7.0 Form's On Error Event and ODBC Error Messages Incompatible

8. Preserve On Commit/Abort

9. Form's On Error Event and ODBC Error Messages incompatible

10. 'Field cannot be zero length' error

11. HELP: Error Msg 16923 when using cursor

12. 'incompatible repository' in Analysis Manager

13. Cursor on column converted from smalldatetime to datetime generates error 16923