Exception Type- System.IndexOutOfRangeException
Exception- Invalid index -1 for this OracleParameterCollection with Count=7.
Source- System.Data.OracleClient
Stack Trace- 
   at System.Data.OracleClient.OracleParameterCollection.RangeCheck(Int32 index)
   at System.Data.OracleClient.OracleParameterCollection.GetParameter(Int32 index)
   at System.Data.OracleClient.OracleParameterCollection.get_Item(String parameterName)
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 62

----------------End---------------11/24/2022 11:23:41 AM
-----------------Start-------------------11/24/2022 11:27:55 AM
11:27:55 AM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1

Source- System.Data.OracleClient
Stack Trace- 
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 67
Line Number- 0

----------------End---------------11/24/2022 11:27:55 AM
-----------------Start-------------------11/24/2022 11:31:25 AM
11:31:25 AM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.InvalidCastException
Exception- Unable to cast object of type 'System.DBNull' to type 'System.Data.OracleClient.OracleLob'.
Source- App_Web_chbsbwcz
Stack Trace- 
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 73
Line Number- 73

----------------End---------------11/24/2022 11:31:25 AM
-----------------Start-------------------11/24/2022 11:32:33 AM
11:32:33 AM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.InvalidCastException
Exception- Unable to cast object of type 'System.DBNull' to type 'System.Data.OracleClient.OracleLob'.
Source- App_Web_chbsbwcz
Stack Trace- 
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 73
Line Number- 73

----------------End---------------11/24/2022 11:32:33 AM
-----------------Start-------------------11/24/2022 11:35:13 AM
11:35:13 AM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.InvalidCastException
Exception- Unable to cast object of type 'System.DBNull' to type 'System.Data.OracleClient.OracleLob'.
Source- App_Web_chbsbwcz
Stack Trace- 
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 73
Line Number- 73

----------------End---------------11/24/2022 11:35:13 AM
-----------------Start-------------------11/24/2022 4:36:21 PM
4:36:21 PM, http://localhost:12680/Taly/Business/GenerateSGL.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "TALY_ASR.GL_PROCESSOR" has been invalidated
ORA-04065: not executed, altered or dropped package body "TALY_ASR.GL_PROCESSOR"
ORA-06508: PL/SQL: could not find program unit being called: "TALY_ASR.GL_PROCESSOR"
ORA-06512: at line 1

Source- System.Data.OracleClient
Stack Trace- 
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at GenerateSGL.searchFile() in f:\Taly\Business\GenerateSGL.aspx.cs:line 269
Line Number- 0

----------------End---------------11/24/2022 4:36:21 PM
-----------------Start-------------------11/24/2022 4:36:26 PM
4:36:26 PM, http://localhost:12680/Taly/Business/GenerateSGL.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "TALY_ASR.GL_PROCESSOR" has been invalidated
ORA-04065: not executed, altered or dropped package body "TALY_ASR.GL_PROCESSOR"
ORA-06508: PL/SQL: could not find program unit being called: "TALY_ASR.GL_PROCESSOR"
ORA-06512: at line 1

Source- System.Data.OracleClient
Stack Trace- 
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at GenerateSGL.loadFile() in f:\Taly\Business\GenerateSGL.aspx.cs:line 67
Line Number- 0

----------------End---------------11/24/2022 4:36:26 PM
