hello there,

i use delphi 2007 and doa 4.1
when my project runs under oracle 11 client it crashes
all doa concerning executes after a while with external exceptions.
under oracle 10.2 client everything is fine.

i tested it on windows xp and vista machine as client,
where server side is either a win2003 or suse-linux
oracle 11 server.

is there a workaround ? or when can i expect a new doa
version that works with ora 11 client ?

delphi project uses no complicated operations.
just about 5 oraclequeries and 1 oracle event,
no threads, 1 oracle session.
optimize propery set to false, because this causes
errors on all clients.

best regards,
claus

Direct Oracle Access 4.0.x and 4.1.x works just fine with the 11g client. What exactly is the error message of the exception?

query execute exception block
just gives "External exception EBF00BAA" in the message.

exception block looks like this:
try
oq.execute;
on e : exception do
flog('...'+e.message);
end;

there is also an application.onexception
handler which is not triggered !

here are some oracleci parms:

ORACLE HOME c:\ora\product\11.1.0\db_1
ORACLE HOME KEY SOFTWARE\ORACLE\KEY_ora1110
ORACLE HOME DIR
ORACLE HOME NAME ora1110
ORACLE HOME LIST ora10201client
ora1110
ORACLE BIN DIR TRUE
ORACLE OCI DLL c:\ora\product\11.1.0\db_1\bin\oci.dll
ORACLE OCI VERSION version 9.2

when i force it to use ora10201client everything is fine:

if you need more information let me know.

greetings,
claus

the forum clock might be wrong !
this post is feb 2nd,2009, 08:41 met

[quote]just gives "External exception EBF00BAA" in the message.[/quote]
There is not much we can do with that. Can you try it on a different PC?

[quote]the forum clock might be wrong !
this post is feb 2nd,2009, 08:41 met[/quote]
That is how it is displayed for me. Maybe you need to set the time offset through "My stuff" > "Preferences"?

i tried it on 3 different pc already:
windows xp sp3, windows vista, windows server 2003

its absolute reproducable that the use of the ora 11
client makes the error, but the time from the start
of the app up to the exception can be a few seconds
or about 1 hour.
i suspect that it occurs when there are heavy execs
on the database.

well i hope you keep on finding a solution for this !

please help !
claus

p.s.: my local clock is GMT+1 but my firefox shows the past timestamp

would be nice if i could get an answer.
i you dont know what it is you can say it.
but giving no answer at all is disappointing.

Sorry, we have no real clues. You can send me a demo application, including scripts to create database objects, so that I can see if it is reproducible.

I have the same problem here with Oracle 11GR1. It just
"started" - and I don't know why ...

I am running the follwing query:

select * from nhdcs.gatesystemeventqueue
where
mandant = :mandant and
trunc(EVENTTIME,'DDD') = :buchungsdatum and
cardnumber = :transponderid
order by EVENTTIME,GateEvent

The Table structure is as follows:

create table GateSystemEventQueue (
Mandant Number (9) not null,
ObjectID Number (9),
UserID Number (9),
GroupID Number (9),
AccessRightID Number (9),
GateSystemEventSEQ number (9) not null,
GateSystemID varchar (30) not null,
Cardnumber varchar (255),
GateEvent number (9) not null,
EventTime Date,
DeviceID varchar (30),
GateSEQ varchar (30),
DateCreated Date,
DateProcessed Date,
Processed number (9),
AES32Reference number(9),
Description varchar (80),
Active number (9) default 1 not null,
Forwarded Date
);
grant all on GateSystemEventQueue to public;
create unique index GateSystemEventQueueIndex1 on GateSystemEventQueue (Mandant,GateSystemEventSEQ);
create index GateSystemEventQueueIndex2 on GateSystemEventQueue (Mandant,DateProcessed);
create index GateSystemEventQueueIndex3 on GateSystemEventQueue (Mandant,Cardnumber,round(EventTime,'DDD'));
commit;

After running the query for a while you get the exception .... there
are about 3500 records in the database

Nils

Okay,

I did some further investigation ... it's the TOracleEvent
what is causing the problem ... when I removed it from
my project everything worked again.

Nils