Description not the right length

[Eelco]

When I describe a procedure, then the length of the column is four times bigger than the column of the table. We are using a UTF8-environment.

The procedure:
PROCEDURE ins_var
(
pi_naam IN alg_variabelen.naam%TYPE
,pi_oms IN alg_variabelen.oms%TYPE
,pi_waarde IN alg_variabelen.initiele_waarde%TYPE
,pi_var_waarde IN alg_variabelen.variabele_initiele_waarde%TYPE
);

In commandwindow
SQL> desc svs_install_pck.ins_var
Parameter Type Mode Default?
------------- --------------- ---- --------
PI_NAAM VARCHAR2(120) IN
PI_OMS VARCHAR2(240) IN
PI_WAARDE VARCHAR2(240) IN
PI_VAR_WAARDE VARCHAR2(14400) IN Y

Tabledefinition
SQL> desc alg_variabelen
Name Type Nullable Default
------------------------- -------------- -------- -------
NAAM VARCHAR2(30)
OMS VARCHAR2(60) Y
INITIELE_WAARDE VARCHAR2(60) Y
ID NUMBER(14)
RELEASE_NR VARCHAR2(15) Y
VARIABELE_INITIELE_WAARDE VARCHAR2(3600) Y

 

[Marco Kalter]

We'll check it out.