Print Thread
Page 2 of 3 1 2 3
Re: TOracleDataset fails on Oracle 10g
#8091 03/13/06 09:52 PM
Joined: Jan 2006
Posts: 10
R
Member
OP Offline
Member
R
Joined: Jan 2006
Posts: 10
Hi Marco,
Is there any chance to have this patch for 28/mar/06?
Best Regards.

Re: TOracleDataset fails on Oracle 10g
#8092 03/29/06 11:29 AM
Joined: Mar 2006
Posts: 5
N
Member
Offline
Member
N
Joined: Mar 2006
Posts: 5
Hi!

We've got the same problem with the TOracelQuery component, though we don't use the rowid column in this case. If we do a select *, we get a access violation in orageneric10.dll, if we select the columns by name everything is fine.

I have not figured out so far, which circumstances are needed for this issue to show up, in some querys it does, in others not. I suspect XMLType-Columns, which we use in some tables.

Maybe this helps in searching.

Re: TOracleDataset fails on Oracle 10g
#8093 03/29/06 09:27 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Is this issue restricted to XMLTYPE columns?


Marco Kalter
Allround Automations
Re: TOracleDataset fails on Oracle 10g
#8094 03/30/06 01:05 PM
Joined: Mar 2006
Posts: 5
N
Member
Offline
Member
N
Joined: Mar 2006
Posts: 5
It seems so at the moment, but since we've updatet our clients recently, I can not confirm this at 100%.

We just encountered another Problem resulting in the same Exception while creating a TXMLType instance, but not every time we do it. The same procedure works once, the second time it crashes.

I will try to get some simple scenarios for those issues, as the second problem now is a urgent one for us. If I am successfull with this, I can provide you these scenarios with source.

Re: TOracleDataset fails on Oracle 10g
#8095 03/30/06 01:28 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
We had several problems with XMLType columns in 10g R2, we had to step back to 10g R1. Something looks to be changed between those releases, and broke DOA compatibility.


LDS
Re: TOracleDataset fails on Oracle 10g
#8096 03/30/06 02:03 PM
Joined: Mar 2006
Posts: 5
N
Member
Offline
Member
N
Joined: Mar 2006
Posts: 5
I can provide some more information regarding the issue:

We use Client 10.1.0.2, Servers 10.1.0.4 and 9.2.0.7

on the 9.2.0.7 server, everything seems to be fine.

The exception occurs every time a select on a xmltype column is executed,
but not the first time it is executed in the actual session. The Problem does not occur,
if the table has more than one xmltype column.
This Problem also occurs, if I execute the select with PL/SQL Developer.

It occurs also when a TXMLType-instance is created after one instance was successfully created.
For this Problem, the amount of xmltype columns in the table does not matter.

If I get more information, I'll post it here.

Re: TOracleDataset fails on Oracle 10g
#8097 03/30/06 02:17 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
noidic: see my post of March 13th - there is a bug filed in Metaling regarding these issues, but I got no reply here.


LDS
Re: TOracleDataset fails on Oracle 10g
#8098 03/30/06 02:32 PM
Joined: Mar 2006
Posts: 5
N
Member
Offline
Member
N
Joined: Mar 2006
Posts: 5
I know, this issue was reported by us, but it's another issue regarding only R2 of 10g, not R1. The actual issue shows of in R1.

Re: TOracleDataset fails on Oracle 10g
#8099 05/10/06 06:20 PM
Joined: Jan 2006
Posts: 10
R
Member
OP Offline
Member
R
Joined: Jan 2006
Posts: 10
mad
Hi Marco,

We are talking and talking about this issue since January and no solutions were proposed yet...

So, is there any chance to have this patch for this month? This year? Next milenium?

Please, don't abandon us!

Best Regards.

Re: TOracleDataset fails on Oracle 10g
#8100 06/08/06 07:11 PM
Joined: Jan 2006
Posts: 10
R
Member
OP Offline
Member
R
Joined: Jan 2006
Posts: 10
Hi Marco,

We were supposed that our Annual Service Contract should cover this kind of issue.

We are waiting for a patch since January...and our clients cannot spend more time...they are now bringing us into court!

Is there any change to have your professional help to solve this problem?

Thanks a Lot!

Best Regards.

Page 2 of 3 1 2 3

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.114s Queries: 13 (0.049s) Memory: 2.5567 MB (Peak: 3.0379 MB) Data Comp: Off Server Time: 2024-05-06 02:27:25 UTC
Valid HTML 5 and Valid CSS