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
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.