Oracle must die with a strange ORA-06502 Error

As a skilled. Net coders and unskilled Oracle users, Oracle always gives me the feeling that this product is disgusting.

Although I have to admit that Oracle is a very good (an) Good (gui) product, it is always so disgusting. For example, the driver is the same as the driver, and the strange mistake encountered today.

The thing is this: when new information is added to the database, the system always reports a ORA-06502 when executing the following script:

Getmaterialinfo () dual

Description: getmaterialinfo is a function that returns varchar2. Well, it seems that there is a problem with the variable size in the function, so we can debug it decisively.

However, a miracle occurred when the following debugging statement was executed:

((;

Yes, nothing happened !!!! This is the normal end !!!!! A miracle happened because nothing happened. What can it be?

Okay, just skip it. Let's just draw a conclusion:

The returned string length exceeds 4000, and the default buffer size is 4000. Therefore, Oracle decisively reports an error (not understanding why the returned type is set to varchar2 (5000) you still need to tangle the return length ...... Please explain ?), Throw an error that cannot be guessed by the description of the error output.

Refer to Solution.

Finally, Oracle must die.