Skip to main content

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

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

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

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

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

Terms & ConditionsAccessibility statement