986280 wrote:You have to add that into a pl/sql page process which should fire on On-Submit
I had a looked at your example, but this is not quite what I am looking for.
I would like to type in any quantity, e.g. 50 in a field and have 50 INSERTs of new rows happen against table instead of 1. Is this possible?
I believe this SQL statement will do the trick, but I am not sure where it should go
BEGIN FOR i IN 1..quantity_from_field LOOP
INSERT INTO inve1 (list,of,columns) VALUES(list, of, values);
END LOOP; END;
Thanks in advance.