 |
|
ORA-02068: following severe error from O.WORLD
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist (WWV-11230)
Failed to parse as ROTHERWEB - select a.reference, to_char(a.received,'DD-MM-YYYY') received, a.date_issued, BCP.detailed_status@O.WORLD(reference, 'STATUS') Status, a.location_line1||' '|| a.location_line2||' '|| a.location_line3||' '|| a.location_line4||' '|| a.location_line5 location, a.development_description, a.applicant_name, a.applicant_address1, a.applicant_address2, a.applicant_address3, a.applicant_address4, a.agent_name, a.agent_address1, a.agent_address2, a.agent_address3, a.agent_address4, PRP_MODULE.get_desc@O.WORLD(a.cat_1,'A29') Policy, PRP_MODULE.get_desc@O.WORLD(a.cat_2,'A30') TPO, a.conserve_area Conservation_Area, a.listed_building, a.site_area, a.grid_ref, '<A HREF="/portal/pls/portal/rotherweb.RPT_DOCS.show?p_arg_names=reference&p_arg_values='||a.reference||'">View Documents</A>' view_documents, nvl(to_char(BCP.max_publicity@O.WORLD(reference,'A'),'DD-MM-YYYY'),'N/A') advertised_date, nvl(to_char(BCP.max_publicity@O.WORLD(reference,'E'),'DD-MM-YYYY'),'N/A') expiry_date, PRP_MODULE.get_desc@O.WORLD(a.officer,'a02') off_code, '<A HREF="/portal/pls/portal/ROTHERWEB.RPT_OFFICER_DETAILS.show?p_arg_names=p_officer&p_arg_values='||a.officer||'">'||PRP_MODULE.get_desc@O.WORLD(a.officer,'A02')||'</A>' OFFICER, a.officer offlink, PRP_MODULE.get_desc@O.WORLD(a.decision,'A13') DECISION, to_char(a.decision_date,'DD-MM-YYYY') decision_date, aa.appeal_ref, to_char(aa.appeal_lodged,'DD-MM-YYYY') appeal_lodged, PRP_MODULE.get_desc@O.WORLD(aa.decision_type,'A27') appeal_decision, to_char(aa.decision_date,'DD-MM-YYYY') appeal_decision_date, decode(a.date_issued, null, 'Comment on this application', null)cons_comments, '<A HREF="/portal/pls/portal/rotheRWEB.RPT_MILESTONE_DATES.show?p_arg_names=application&p_arg_values='||a.reference||'">Milestone Dates</A>' milestone, decode(BCP.bcp_doc_check@O.WORLD(a.reference), 'TRUE', 'Documents', NULL)documents, decode(bcp.bcp_conditions_check@o.world(a.reference), 'TRUE','<A HREF="/portal/pls/portal/ROTHERWEB.RPT (WWV-08300)
|
|
Failed to parse query.
