Hello,

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.

Dan.