1
0
-1

Good afternoon, I would need help with a variable topic in a table in ORACLE. The field in ORACEL is VC4000 and fails to read it from Uniface 9.7 with the following error:

I / O function: O, mode: 0, on file / table: POLIZACERTIFICADOENDOSO
ORACLE Driver Error [-80]: Column has incorrect ORACLE storage format: Table POLIZACERTIFICADODOOSO, Column DE_OBSERVACION, expected storage format LONG, actual storage format is VARCHAR2

I / O function: O, mode: 0, on file / table: CAJAEGRESO
ORACLE Driver Error [-80]: Column has incorrect ORACLE storage format: Table CAJAEGRESO, Column DE_OBSERVACION, expected storage format LONG, actual storage format is VARCHAR2

Could you tell me how the field should be declared in ORACLE

Thank you

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Thanks for the help, the problem has been solved. Thank you

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi Pedro,

        Uniface driver for Oracle as standard manage STRING fields mapped to VARCHAR2 up to 2000 characters.
        To enable it to manage VARCHAR2 up to 4000 characters you need to add to your USYS$ORA_PARAMS the following parameter:
        USYS$ORA_PARAMS = varchar2_4k
        Then you could define your column DE_OBSERVACION as S/VC4000 into your application model.

        More info:
        Oracle data packing
        Oracle varchar2_4k

        Let's give it a try.

        Gianni

          CommentAdd your comment...