NUMBER IN A LIST
I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns error ORA-01722 when I have more than 1 number in the list. Any reasonable suggestions will be greatly appreciated.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 15, 2008 2:31 PM
UPDATED:
October 15, 2008 3:53 PM
Answer Wiki:
ORA-01722 is raised when you are trying to convert a character string to a number, but the string is not really a number.
It is not clear enough to me what are you trying to do.
Could you please paste your update statement here, and explain what are the data types of the involved table columns ?
I'm pretty sure that more useful answers will be provided after that.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
