when writing insert sql statements with python + cx_oracle, the error message is an invalid ORA-01722: number. The field types of the two tables are the same, and they are executed in PL/SQL, and the field that reported the error is found. But after looking at it carefully for a long time, I didn"t find out what was wrong. I hope the bosses will show us the way. Here is a screenshot:
1. First of all, if you report an error and an invalid number, it is determined that the field format does not match. For the sql statement, which is more complex than mine, it is also the same. Break it down into sentences
.2. After decomposition, to query the data, first pay attention to the fields of the associated query, then focus on the number type, and then find the varchar type (whether the varchar type needs to pay attention to whether the length exceeds the length)
3. Query the data, locate the wrong data, and then see whether to change the data or add Filter or change the table
-- there is a stupid way to use the binary search method to locate, such as 10 fields, first comment the last 5 fields to see if there is an error, if not, annotate the first 5 fields, check the last 5 fields, and so on, locate to a certain field, remember this error report, the next time you encounter it, you can locate it at a glance, if you can't, then take a second look
." learn about "
"