SELECT scbcrse_title, scbdesc_text_narrative FROM scbcrse t1, scbdesc c1 WHERE scbdesc_term_code_eff = (select max(scbdesc_term_code_eff) from scbdesc c2 WHERE c2.scbdesc_subj_code = c1.scbdesc_subj_code AND c2.scbdesc_crse_numb = c1.scbdesc_crse_numb /* AND c2.scbdesc_term_code_eff <= to_char(sysdate,'yyyymm') */) AND nvl(scbdesc_term_code_end,'999999') >= to_char(sysdate,'yyyymm') AND scbcrse_eff_term = (select max(scbcrse_eff_term) from scbcrse t2 WHERE t2.scbcrse_subj_code = t1.scbcrse_subj_code AND t2.scbcrse_crse_numb = t1.scbcrse_crse_numb /* AND t2.scbcrse_eff_term <= to_char(sysdate,'yyyymm') */ ) AND scbcrse_subj_code = scbdesc_subj_code AND scbcrse_crse_numb = scbdesc_crse_numb AND scbdesc_subj_code = :courseprefix AND scbdesc_crse_numb = :coursenum
System.Data.OracleClient.OracleException: ORA-01033: ORACLE initialization or shutdown in progress
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
at ASP.programsofstudy_schoolofagandnr_agriculturalbusiness_coursedetails_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in D:\DFS_SYSTEM29\WebApplications\www.webapps.morrisville.edu\programsofstudy\globalincs\coursedetailcode.ascx:line 29
