Cual es el error?
debes ponerle cuando salir del cursor.
Código SQL:
Ver originalLOOP
FETCH cursX INTO or_nbr,symb,or_action,shar, price, st, event_tim, tra_id, market;
EXIT WHEN NOT FOUND;
INSERT INTO Layers(order_nbr,symbol,orden_action, shares,order_price,state ,event_time, trader_id, market_id)
VALUES (or_nbr,symb,or_action,shar, price, st, event_tim, tra_id, market) ;
END LOOP;
CLOSE cursX;