Example 10-1: Sample PL/SQL code block

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;