Update ZCSMS_BPH_CUST_RD set GPSX='null' where partner='0007927509' such a statement, a invalid number error prompt,
Why don't tangle useless GPSX=null, I want to update into a string, the string value is "null", but appeared the mistake,
Because do not conform to my understanding, so I want to know why, for a great god help,
Also this table, no constraints, triggers, such as
The database is oracle11g,
Error message is as follows:

The field type is as follows:

CodePudding user response:

Problems found, someone in my field and add the to_number index,,

CodePudding user response:

reference 1st floor xulei0412 response:

problems found, I was in the field and add the to_number index,,

The question really is not easy to find