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 (0x80131938): ORA-12516: TNS:listener could not find available handler with matching protocol stack
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at ASP.banner_courses_coursedescription_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in \\10.200.1.1\WebApplications\www.webapps.morrisville.edu\programsofstudy\globalincs\coursedetailcode.ascx:line 29
Fall 2009 Course Listings Morrisville State College
Morrisville State College - Fall 2009
Morrisville Campus Course Sections (as of April 22, 2009)