RDB Blob issue

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Wed, 16 Mar 2005 13:17:23 -0800


Hi all.  we recently upgraded our RDB DB to 7.1 and now get the following
error when touching a table containing a blob field when using 840d.

(viewable_letter_blob is the blob field)  This works under 710g1.  If you
don't reference the blob field, the access is ok.

any ideas?

cheers



> access letter_issued in sfas_database

> select if not viewable_letter_blob is null

> rep letter_idx

> go

*W* Data access error. (LETTER_ISSUED)

*W* DMS-E-GENERAL, A general exception has occurred during operation 'open

blob'. (LETTER_ISSUED)

*W* %SQL-F-CURALROPE, Cursor CR8 was already open (LETTER_ISSUED)

*W* End of segmented string. (LETTER_ISSUED)

2005-MAR-16                       SFAS_WWW_DIC                         PAGE
1 
 

      Letter

       Idx

 

     900,121,251