thoughthaus

here’s a way to add some minimal exception logging to an Oracle stored procedure.
here’s a simple loop from a SP:

OPEN someInsertCursor;
LOOP
FETCH someInsertCursor INTO someInsertRec;
EXIT WHEN someInsertCursorr%NOTFOUND;
INSERT INTO some_table (id) values (someInsertRec.OD_PAIR_DEP_ID);
END LOOP;
CLOSE someInsertCursor;

what if sometimes the record you try to insert violates […]

Pandora is the most useful tool for finding new music I’ve found. You can create a personal music stream based on your favorite artists or songs. Just enter a band’s name and pandora will start playing all this music that’s suppose to be like the band you entered. Check it out. […]