Devart Forums

Hello, I have the next declaration of stored procedure.

PROCEDURE PET_PRUEBA_RESULTADO(IDPETICIONPRUEBA in NUMBER, NACCION in NUMBER, IDPRUEBA in NUMBER, IDESTADORESULTADO in NUMBER, PREFIJO in varchar2, NRESULTADO in binary_double, RESULTADO in varchar2, TRESULTADO in CLOB, TRESULTADOE in CLOB, PATOLOGIA in NUMBER)

When prepare the execution of the procedure, I get the error Unsupported datatype [101]. The problem is with stored procedures and parameters of type binary_double.

I'm using direct mode connection.

Is this a bug?

When working with Oracle database in Direct Mode, UniDAC doesn't support the following data types: OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT .
You can find more detailed information in the UniDAC help topic :
https://www.devart.com/unidac/docs/?oraprov_article.htm
We plan to add the possibility of working with these types in the Direct mode in the future.

Thank you Maxim, can you review this thread?
viewtopic.php?f=28&t=32898&hilit=binary+double

Indeed, support for BINARY_DOUBLE and BINARY_FLOAT fields in Direct Mode was added in the UniDAC version 6.1.3 on 14-Apr-2015. However, using these data types is available only when working with tables, that contain fields of corresponding types. Working with procedure parameters of BINARY_DOUBLE and BINARY_FLOAT types is still unavailable. We are going to add full support for BINARY_DOUBLE and BINARY_FLOAT data types shortly.

We have already added full support for BINARY_DOUBLE and BINARY_FLOAT ORACLE data types, and the updates will be included in the next UniDAC build. We plan to release the build in 2 week.

Thank you