error when Direct=true and parameters more than 255

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
funtik1986
Posts: 1
Joined: Wed 22 Dec 2010 18:11
Contact:

error when Direct=true and parameters more than 255

Post by funtik1986 » Wed 22 Dec 2010 18:57

Hi,
I work on Borland Developer Studio 2007 with ODAC 6.90
I have client oracle : Oracle Database 9i

I have a problem.
I generate script where i have more than 255 parameters.

for example:
declare
vTmp varchar2(255);
begin
vTmp := :p1;
vTmp := :p2;
vTmp := :p3;
...
vTmp := :p256;
end;

When i work in Direct = false then works fine
When i work in Direct = true then "exception class N_28 with message 'Unknown error 1'"
When i work in Direct = true and(count parameters 255 or less) then works fine

Can everyone help me?
thanks

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

Post by AlexP » Thu 23 Dec 2010 08:25

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Fri 24 Dec 2010 11:23

Hello

We have fixed this issue. This fix will be included in the next ODAC build.

Post Reply