问Oracle PL/SQL -跳过抛出错误的记录的返回表

EN

CREATE FUNCTION to_wkbgeometry_silent (geometry IN SDO_GEOMETRY)
    RETURN BLOB IS
BEGIN
    RETURN SDO_UTIL.to_wkbgeometry (geometry);
EXCEPTION
    WHEN OTHERS THEN
        RETURN NULL;
END to_wkbgeometry_silent;

SELECT *
FROM   (SELECT to_wkbgeometry_silent (geometry) AS geo, s_route, block_id
        FROM   geom_table)
WHERE  geo IS NOT NULL;

SELECT CASE GEOMETRY WHEN 1 THEN 1 WHEN 2 THEN 2 ELSE NULL END
  FROM (SELECT 1 AS GEOMETRY FROM DUAL -- Fake Table
        UNION ALL
        SELECT 2 AS GEOMETRY FROM DUAL
        UNION ALL
        SELECT 3 AS GEOMETRY FROM DUAL);

SELECT 
    CASE GEOMETRY WHEN 1 THEN SDO_UTIL.TO_WKBGEOMETRY(GEOMETRY) WHEN 2 THEN SDO_UTIL.TO_WKBGEOMETRY(GEOMETRY) ELSE NULL END,
    S_ROUTE, 
    BLOCK_ID 
FROM GEOM_TABLE;