Oracle Forms 6i trying to read a list of numbers separated by a comma
Hello, I have an Oracle Forms 6i form with a text field that I want users to be able to put in a list of numbers seperated by commas, eg 12345,67890,34567 etc. From this list, I want to be able to use the list of numbers in an IN statement such as: CURSOR c_policy IS [...]

Answer Question   |  March 18, 2009  11:34 AM
ORA-01722, Oracle error messages, Oracle Forms 6i

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 [...]

Answer Question   |  October 15, 2008  2:31 PM
ORA-01722, Oracle error messages