Executenonquery is returning error 'No size set for variable length data type: String' while executing Oracle Stored Procedure

database
activities
sql
oracle

#1

I am trying to execute an Oracle stored procedure which has 2 input parameters and 1 output parameter. I am getting below error when I ran the project. I could execute the project successfully when the oracle procedure doesn’t has any output parameter. How to set the size of oracle output parameter?

Execute Procedure Proj has thrown an exception

Source: Execute non query

Message: Parameter ‘O_MESSAGE’: No size set for variable length data type: String.

Exception Type: Exception

System.Exception: Parameter ‘O_MESSAGE’: No size set for variable length data type: String.

Server 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.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)_
_ at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()_
_ at UiPath.Database.DatabaseConnection.Execute(String sql, Dictionary`2 parameters, CommandType commandType)_
_ at UiPath.Database.Activities.ExecuteNonQuery.<>c__DisplayClass34_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.ExecuteNonQuery.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)_