Order of Operation for SQL
595448Nov 4 2008 — edited Nov 4 2008Im not sure if I am in the right form.
I have an apex application that sends over a item_id into table a
I have an insert statement that works where it puts the clob and blob into a table b.
However I need a next_val for item_id to insert another file name aswell in Table a. But after the clob procedure for table b it does not allow me to insert the next
statement but it does keep the value.
Example
File Name.PDF
File2 Name.TIFF
Now they are entered the same time with the same information. How do I get the next value to accep the next file name without hurting the table b clob proceedure.
I hope I made some sort of sense.