Conference orarep::nomahs::rdb_60

5024.0. "RDMS$$COMPILE_RTN_EXPR on alter column" by ukvms3.uk.oracle.com::LWILES (Louise Wiles, UK Rdb support) Thu Feb 13 1997 07:44

    Hi,

    Rdb7
    VMS V6.2-1h1

    A customer of mine is getting a bugcheck when trying to alter 4 columns
    from varchar to char. If he alters the 4 individually, then it works.

    The exception is

    RDMS$$COMPILE_RTN_EXPR +7A8 %SYSTEM-F-ACCVIO, access violation

    The database was created under V6.1 & rmu/converted to V7.0. He tried a
    small test database which wasn't converted, and that was successful.

    There are 2 varchar(1) columns being changed to char(1), and 2
    varchar(40)'s being changed to char(40). There are about 25 columns in
    the table.

    It generates the following MBLR (which is the same as that generated
    here which works ok):

    0000 (00000) MBLR$K_VERSION_2     (This is a CHANGE) 
    0001 (00001) | MBLR$K_RELATION_DEF  "NETWORK_OBJECT_TYPES" 
    0017 (00023) |   MBLR$K_CHANGE_FIELD 
    0017 (00023) |   | MBLR$K_FIELD_DEF  "CES_CLASS_IND" 
    0026 (00038) |   |   MBLR$K_FIELD_NAM  "SQL$1CHR" 
    0030 (00048) |   | MBLR$K_FIELD_END 
    0032 (00050) |   MBLR$K_CHANGE_FIELD 
    0032 (00050) |   | MBLR$K_FIELD_DEF  "AUTO_OPERATING" 
    0042 (00066) |   |   MBLR$K_FIELD_NAM  "SQL$1CHR" 
    004C (00076) |   | MBLR$K_FIELD_END 
    004E (00078) |   MBLR$K_CHANGE_FIELD 
    004E (00078) |   | MBLR$K_FIELD_DEF  "NAME" 
    0054 (00084) |   |   MBLR$K_FIELD_NAM  "SQL$40CHR" 
    005F (00095) |   | MBLR$K_FIELD_END 
    0061 (00097) |   MBLR$K_CHANGE_FIELD 
    0061 (00097) |   | MBLR$K_FIELD_DEF  "OBJECT_CATEGORY" 
    0072 (00114) |   |   MBLR$K_FIELD_NAM  "SQL$40CHR" 
    007D (00125) |   | MBLR$K_FIELD_END 
    007E (00126) | MBLR$K_RELATION_END 

    Any clues what could be happening here?

    Thanks,
    Louise.

I have no idea why this ALTER would end up in that routine. Please provide a
reproduceable case (database and scripts) and someone can take a look.

Ian