Oracle error in call to stored procedure with binary double

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Oracle error in call to stored procedure with binary double

Post by cointec » Mon 16 May 2016 13:58

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?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle error in call to stored procedure with binary double

Post by MaximG » Tue 17 May 2016 10:59

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.

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: Oracle error in call to stored procedure with binary double

Post by cointec » Tue 17 May 2016 15:42

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle error in call to stored procedure with binary double

Post by MaximG » Wed 18 May 2016 08:29

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle error in call to stored procedure with binary double

Post by MaximG » Mon 30 May 2016 10:06

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.

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: Oracle error in call to stored procedure with binary double

Post by cointec » Sun 12 Jun 2016 11:56

Thank you

Post Reply