REM $Id$ REM From "Learning Oracle PL/SQL" page 290 REM Simple illustration of using OWA_PATTERN.MATCH DECLARE text VARCHAR2(2000) := ' text, pat => pattern, backrefs => components) THEN DBMS_OUTPUT.PUT_LINE('session id is ' || components(1)); ELSE DBMS_OUTPUT.PUT_LINE('no session id found'); END IF; END; /