System.Data.OracleClient.OracleException (0x80131938): OCI-22053: overflow error

Help
1

Hi,

I am executing below query and when the last name value contain ‘-’, it throws the error “System.Data.OracleClient.OracleException (0x80131938): OCI-22053: overflow error” . If I remove the hyphen, the query executes fine. Please help to resolve this issue.

Query:

“select * from tablename where LAST_NM=‘Reynold-Joseph’”

Complete Error:

System.Data.OracleClient.OracleException (0x80131938): OCI-22053: overflow error

Server stack trace:
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleNumber.ToDecimal(OciErrorHandle errorHandle, Byte value)
at System.Data.OracleClient.OracleColumn.GetDecimal(NativeBuffer_RowBuffer buffer)
at System.Data.OracleClient.OracleColumn.GetValue(NativeBuffer_RowBuffer buffer)
at System.Data.OracleClient.OracleDataReader.GetValues(Object values)
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object values)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.LoadAdapter.FillFromReader(DataTable dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
at UiPath.Database.DatabaseConnection.ExecuteQuery(String sql, Dictionary`2 parameters, Int32 commandTimeout, CommandType commandType)
at UiPath.Database.Activities.ExecuteQuery.<>c__DisplayClass38_0.b__0()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object args, Object server, Object& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at UiPath.Database.Activities.ExecuteQuery.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Thanks,
Nikitha

2

Does you table contain any Numeric/Decimal column? If yes then please try the below:-

Instead of using select * from tablename

You can specify the precision that you require in round().

Select round(fieldname,2) as fieldname from tablename

For more info please go through the following link:- c# - Getting overflow error when executing pl/sql query - Stack Overflow

2 Likes
3

Yes, table contains numeric column. I changed the Select * to Select firstname from the table
and I got the output. Thanks for the suggestion.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.