| view problem [message #408204] |
Mon, 15 June 2009 05:23  |
rajasekhar857
Messages: 500
Registered: December 2008
|
Senior Member |
|
|
why in oracle sql developer on left hand side when i click on view tab it is showing 'x' mark on some view names even though it is proper and it is showing no errors,but it is displaying x mark on them.can you explain me why it is diplaying like that
CREATE OR REPLACE FORCE VIEW "EZEMRXCCHIT"."EMRVWSCREENINGDETAILS" ("SCREENING_ID", "SCREENING_REFERENCE_ID", "PATIENT_ID", "RECORD_DATE", "COMMENTS", "USER_LOGIN", "PATIENT_CONDITIONS", "STATUS", "ENCOUNTER_ID", "DESCRIPTION") AS
(
SELECT SCREENING_ID,SCREENING_REFERENCE_ID,PATIENT_ID,RECORD_DATE,COMMENTS,
USER_LOGIN,PATIENT_CONDITIONS,EMRPatientScreeningDetails.STATUS,ENCOUNTER_ID,DESCRIPTION
from EMRPatientScreeningDetails
inner join EMRScreenImmunLkup on SCREENING_REFERENCE_ID=SCREEN_IMMUN_ID
where EMRPatientScreeningDetails.STATUS='Pending'
);
|
|
|
|
| Re: view problem [message #408205 is a reply to message #408204] |
Mon, 15 June 2009 05:35  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
Try refreshing the list of views.
And please dit your post so that your code does not exceed 80 characters per line.
Thanks.
|
|
|
|
| Re: view problem [message #408206 is a reply to message #408205] |
Mon, 15 June 2009 05:38 |
rajasekhar857
Messages: 500
Registered: December 2008
|
Senior Member |
|
|
|
after refreshing too i am having the x mark.what would be the reason for this .will it effect anything or else i have to compile the view again as it is having some data in it.will it effect view data after recreating same view.
|
|
|
|
|
|
| Re: view problem [message #408211 is a reply to message #408204] |
Mon, 15 June 2009 05:54 |
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
All the x means is that the object is marked as invalid. This doesn't necessarily mean anything is wrong with it.
Whenever you change an object in the database all the objects that reference it are marked as invalid automatically.
So for example, if you change a table, all the views and stored procs that reference that table will be marked as invalid.
To get rid of the x recompile the view.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
