How to return BLOB values from PL/SQL using ODAC?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rmovchan
Posts: 8
Joined: Tue 09 Nov 2004 01:23

How to return BLOB values from PL/SQL using ODAC?

Post by rmovchan » Wed 02 Nov 2011 06:33

I've tried to pass BLOBs from a PL/SQL procedure using BLOB type parameters (I did set ParamType to ptOutput), and I always get the value NULL. Am I doing something wrong? I'm using ODAC 5.80.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Wed 02 Nov 2011 12:05

Hello,

You are using a rather old version of ODAC, try to install the latest ODAC version (ODAC 8.0.2), and if the error persists, please send us a script to create the procedure and a small application demonstrating the problem.

Post Reply