ID AUTO NUM GANARETOR

 SELECT NVL(MAX(ID),1000)+1 INTO :P32_ID FROM ITEMS;