Problem with BFile

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Freezer_86
Posts: 9
Joined: Thu 14 Feb 2013 09:11

Problem with BFile

Post by Freezer_86 » Mon 09 Oct 2017 13:33

I'm try to get BFile from Oracle with sql like this:

Code: Select all

select ph.parent parent, BFILENAME('PHOTO', ph.idobject || '_500x500.JPG') "500x500",
                    idobject,
                    min(ph.idobject) over (partition by parent) minID
             from "#MYTABLE" ph 
Executing this raise exception "OCI function is not linked".
Commenting of BFile field - all works, but i don't have data which i want to get.

I try to do it on Delphi 7, Delphi Berlin, Odac 9.6.20, Odac 10.1.3 Beta. In all combinations - same error.
I use Direct mode and Oracle Database 10g Enterprise Edition Release 10.2.0.3.0.
Same SQL works correctly in PL\SQL Developer.

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

Re: Problem with BFile

Post by MaximG » Thu 12 Oct 2017 13:47

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Freezer_86
Posts: 9
Joined: Thu 14 Feb 2013 09:11

Re: Problem with BFile

Post by Freezer_86 » Mon 13 Nov 2017 08:38

Hi again!
Can you give me approximate time for fix? I mean day, week, month or half of year.
I need to say something to my customers.

Freezer_86
Posts: 9
Joined: Thu 14 Feb 2013 09:11

Re: Problem with BFile

Post by Freezer_86 » Fri 19 Jan 2018 11:31

Is it fixed in latest release build?

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

Re: Problem with BFile

Post by MaximG » Fri 19 Jan 2018 14:30

We continue to work on fixing the described error. Currently, we are busy testing the changes made to the source code of our product to fix it. Therefore, these changes were not included in the latest version of ODAC 10.1.4 (18-Jan-2018). We hope for a final result in the very near future, and we will immediately let you know.

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

Re: Problem with BFile

Post by MaximG » Wed 14 Mar 2018 11:10

We implemented support for working with the BFILE type fields when using the Direct Mode. Necessary changes will be available in the next release of our product. At present, as a workaround, we can offer you a night build of ODAC, including these changes. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( devart.com the "Support"\"Request Support" menu)

Post Reply