[Source] ORA-01008:并非所有的变量都已绑定

I encountered a very common problem today: ORA-01008: Not all variables are bound, looking at the wrong prompt, always thinking that my variables and values are not symmetrical, checking many times, and finally not withdrawing, or searching on the Internet, searching for many methods, all saying that things are because their variables and values do not correspond to each other. Later, I accidentally saw a sentence, which may be caused by the value of the variable being null, not the value sum and the variable do not correspond to each other. After checking, it is found that there is indeed a value that is null, not a space, and then change the value to a space, just do it. In BS systems, &nbsp is used instead of spaces (there is an escape process in the foreground and background of spaces in bs).

   I hope the solution can help friends who encounter the same problem!