Datatype size difference in table and PL/Sql block

Datatype size difference in table and PL/Sql block

 

  

Hello DBA Gurus,

I am having a table which contains a field
with datatype varchar2 (22).



But the data stored will be always less than or equal to 12 bytes.



In my PL/SQL block, I am fetching this data. Here, its data type is
varchar2 (12).



What are the problems that I face because of the inconsistency in size?



Should I reduce the size in the table structure?



Please reply...

Thanking You in advance

Regards,
Raj




Oracle LazyDBA home page