Start a new topic

triggers in the tree ?

[This topic is migrated from our old forums. The original author name has been removed]

Hi roger,
I can't see my triggers in the schema tree. The triggers as children of table will be ok but the separate triggers leaf is not. In oracle there are triggers possible that are not related to a table so the existence of this leaf is very welcome.


regards,
Ronald.

[This reply is migrated from our old forums.]

Re: triggers in the tree ?
Hi Ronald, Can you please post/email a short "create trigger" script that has no dependencies with tables? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: triggers in the tree ?
--/
create trigger logon after logon on schema
DECLARE
   seq_sql VARCHAR(200) := 'alter session set sql_trace = true';
   cursor_handle INTEGER := DBMS_SQL.open_cursor;
   execute_ddl INTEGER;
BEGIN
    if (USER = 'FUNNY' )
    then
        DBMS_SQL.parse (cursor_handle, seq_sql, DBMS_SQL.native);
        execute_ddl := DBMS_SQL.execute (cursor_handle);
        DBMS_SQL.close_cursor (cursor_handle);
     end if;
END;
/
[This reply is migrated from our old forums.]

Re: triggers in the tree ?
Thanks Ronald! This will be fixed in next version. Regards Roger Ps. Let me know if you want the updated database profile now.