To find out the object(s) created by particular session_id

[jmodic]

Damn, I've forgot that this forum doesn't like some of the characters, so some of my code was filtered out. The trigger body should be (using leading "-" to make it more readable):

CREATE OR REPLACE my_trigger BEFORE INSERT ON my_table FOR EACH ROW
DECLARE
--msg_var VARCHAR2(2000);
BEGIN
--DBMS_APPLICATION_INFO.READ_CLIENT_INFO(msg_var);
--IF msg_var = 'Skip my_trigger' THEN
----NULL;
--ELSE
---- ...trigger logic....
--END IF;
END;
/