How can we help you today?
triggers in the tree ?
3 CommentsSorted by Oldest First
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: triggers in the tree ?
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 ?
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;
/
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;
/
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: triggers in the tree ?
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.
anonymous
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.