Shulou(Shulou.com)06/01 Report--

Oracle needs to pay attention to when setting up a procedure:

1. When writing procedure, if the specification of the quantity refers to the bit attribute of other tables

For example, in the form of em_card.card_tm%type, you need to pay attention to the character type of the reference bit, especially the char type.

If the attribute of a bit is char (5), and the length of the actual value you send into the value is 3 digits, the value is stored in the value.

The value in is the space of the actual value + 2 lengths.

For bits of the char type, if the actual length of its store is less than the length set by the bit, it will increase the space after it.

This is the difference between char and varchar2.

two。 On the face of it, the length of the volume is only 3 digits, but if you update the value to other values with a length of 3, the insert will be displayed.

Error with too long value

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.