Devart Forums

Posted: **Mon 09 Oct 2017 13:33**

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

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.

Posted: **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.

Posted: **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.

Posted: **Fri 19 Jan 2018 11:31**

Is it fixed in latest release build?

Posted: **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.

Posted: **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)

Devart Forums

Problem with BFile

Problem with BFile

Re: Problem with BFile

Re: Problem with BFile

Re: Problem with BFile

Re: Problem with BFile

Re: Problem with BFile