oracle 11 client and doa 4.1 external exception
|
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany
Member
|
OP
Member
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany |
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
Claus Reinhardt
Inforent GmbH Stephanstrasse 3 60313 Frankfurt am Main Germany
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Aug 1999
Posts: 22,216
Member
|
Member
Joined: Aug 1999
Posts: 22,216 |
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?
Marco Kalter Allround Automations
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany
Member
|
OP
Member
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany |
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
Claus Reinhardt
Inforent GmbH Stephanstrasse 3 60313 Frankfurt am Main Germany
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany
Member
|
OP
Member
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany |
the forum clock might be wrong ! this post is feb 2nd,2009, 08:41 met
Claus Reinhardt
Inforent GmbH Stephanstrasse 3 60313 Frankfurt am Main Germany
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Aug 1999
Posts: 22,216
Member
|
Member
Joined: Aug 1999
Posts: 22,216 |
[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"?
Marco Kalter Allround Automations
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany
Member
|
OP
Member
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany |
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
Claus Reinhardt
Inforent GmbH Stephanstrasse 3 60313 Frankfurt am Main Germany
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany
Member
|
OP
Member
Joined: Sep 2007
Posts: 8 Frankfurt am Main, Germany |
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.
Claus Reinhardt
Inforent GmbH Stephanstrasse 3 60313 Frankfurt am Main Germany
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Aug 1999
Posts: 22,216
Member
|
Member
Joined: Aug 1999
Posts: 22,216 |
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.
Marco Kalter Allround Automations
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Jul 2000
Posts: 27 Nettersheim-Marmagen, Germany
Member
|
Member
Joined: Jul 2000
Posts: 27 Nettersheim-Marmagen, Germany |
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
|
|
|
Re: oracle 11 client and doa 4.1 external exception
|
Joined: Jul 2000
Posts: 27 Nettersheim-Marmagen, Germany
Member
|
Member
Joined: Jul 2000
Posts: 27 Nettersheim-Marmagen, Germany |
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
|
|
|
|
|