Oracle 10g R2 BLOB Problem with ODAC

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sima
Posts: 1
Joined: Thu 25 Aug 2005 08:15
Contact:

Oracle 10g R2 BLOB Problem with ODAC

Post by sima » Thu 25 Aug 2005 09:06

Hi!

I have an intresting problem with ODAC + Oracle 10g R2.
Server: Win2003Adv Server with ServicePack2, Oracle 10g R2
Client: Xp without ServicePacks, Delphi6, ODAC 4.0.0 And 5.55.0.20 !

Oracle function:
Function teszt( i_blobparam IN BLOB ) return NUMBER IS
BEGIN
.
.
.
RETURN 0;
END;

Calling:
sto.ParamByName('i_blobparam').ParamType := ptInput;
sto.ParamByName('i_blobparam').AsBLOBLocator.LoadFromFile( ...File... );
sto.Execute;

Error:
ORA-12571, ORA-00600, "Operation not allowed when the connection is closed"

This Technology Working Succesfully with Oracle 10g !!! :shock:

How can solve we this problem ?

by

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Thu 25 Aug 2005 11:49

Sorry, we cannot reproduce your problem. We need more detailed description i.e. complete sample to demonstrate your problem and script to create server objects.
Please, send a message to our ODAC support e-mail address.

Post Reply