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.SETTLE_BR_EDITOR" has been invalidated
ORA-04065: not executed, altered or dropped package body "TALY_ASR.SETTLE_BR_EDITOR"
ORA-06508: PL/SQL: could not find program unit being called: "TALY_ASR.SETTLE_BR_EDITOR"
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 SettleBR.loadPCodes() in f:\Taly\Business\SettleBR.aspx.cs:line 139

----------------End---------------11/30/2022 11:30:39 AM
-----------------Start-------------------11/30/2022 4:20:49 PM
4:20:49 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06550: line 1, column 30:
PLS-00302: component 'GET_TALYTXN_RECS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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 GenerateTaly.searchFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 272
Line Number- 0

----------------End---------------11/30/2022 4:20:49 PM
-----------------Start-------------------11/30/2022 4:21:01 PM
4:21:01 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06550: line 1, column 30:
PLS-00302: component 'GET_TALYTXN_RECS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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 GenerateTaly.searchFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 272
Line Number- 0

----------------End---------------11/30/2022 4:21:01 PM
-----------------Start-------------------11/30/2022 4:21:37 PM
4:21:37 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06550: line 1, column 30:
PLS-00302: component 'GET_TALYTXN_RECS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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 GenerateTaly.searchFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 272
Line Number- 0

----------------End---------------11/30/2022 4:21:37 PM
-----------------Start-------------------11/30/2022 4:25:36 PM
4:25:36 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GENERATE_TALYTXN_OUTFILE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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 GenerateTaly.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 70
Line Number- 0

----------------End---------------11/30/2022 4:25:36 PM
-----------------Start-------------------11/30/2022 4:26:09 PM
4:26:09 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Data.OracleClient.OracleException
Exception- ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GENERATE_TALYTXN_OUTFILE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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 GenerateTaly.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 70
Line Number- 0

----------------End---------------11/30/2022 4:26:09 PM
-----------------Start-------------------11/30/2022 4:30:08 PM
4:30:08 PM, 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 GenerateTaly.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 70
Line Number- 0

----------------End---------------11/30/2022 4:30:08 PM
-----------------Start-------------------11/30/2022 4:30:56 PM
4:30:56 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
Exception Type- System.Exception
Exception- Parameter 'p_File_Name': No size set for variable length data type: String.
Source- System.Data.OracleClient
Stack Trace- 
   at System.Data.OracleClient.OracleParameterBinding.PrepareForBind(OracleConnection connection, Int32& offset)
   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 GenerateTaly.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 70
Line Number- 0

----------------End---------------11/30/2022 4:30:56 PM
-----------------Start-------------------11/30/2022 4:31:48 PM
4:31:48 PM, http://localhost:12680/Taly/Business/GenerateTaly.aspx, 1, , GenerateBDCFile, 
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 GenerateTaly.loadFile() in f:\Taly\Business\GenerateTaly.aspx.cs:line 73
Line Number- 0

----------------End---------------11/30/2022 4:31:48 PM
