var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: System Trigger
I have defined system trigger after CREATE
when doing CREATE OR REPLACE VIEW
inside the trigger
I can select the view source using:
SELECT text FROM ALL_VIEWS WHERE VIEW_NAME=UPPER(ora_dict_obj_name);
but I can't get to the column definitions
SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE TABLE_NAME=UPPER(ora_dict_obj_name)
(I've also tried sys.col, no luck)
I can select those columns with no problem after the triger completes using the same SQL statement.
All of this this works for Tables normaly.
Thanks for any suggestions.