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
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: