DECLARE symbol VARCHAR2(40); price NUMBER; lastTrade DATE; BEGIN SELECT ticker_symbol, selling_price, trade_date INTO symbol, price, lastTrade FROM stock_trades WHERE transaction_id = 12345; EXCEPTION WHEN NO_DATA_FOUND THEN MyErrorHandlingProcedure(12345); END; |