Critical Problem Editing View Source

CanadaPete

Member
Again I love this product.
I got caught on a critical defect.
In TOAD the view source is
CREATE OR REPLACE FORCE VIEW apps.gdc_appr_msg_log_v( appr_msg_log_id )
AS SELECT NVL(msglog.appr_msg_log_id,0) FROM gdc_appr_msg_log msglog;

BUT PLSQL Developr ver 7 the view source is (will not even compile)
CREATE OR REPLACE VIEW apps.gdc_appr_msg_log_v
AS SELECT NVL(msglog.appr_msg_log_id,0) FROM gdc_appr_msg_log msglog;

For the time being I have borrowed a TOAD license.
Please advise
Hopefully it is a setting somewhere
A co-worker does not have this problem so it must a setting
 
Last edited:
SOLVED

I had tried to open as the wrong user which only had restricted access to the DDL.

Sorry about bothering you.
 
Back
Top