Access violation at executing Stored Procedure

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Mon 13 May 2013 16:17

Hello.
I removed the transaction start/commit and it worked successfully.
But we can not work without transactions.

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Tue 14 May 2013 10:06

Hello,

Try to reproduce the problem on a "clean" PC (without Delphi and our dbExpress driver), having copied only the application and the dbexpoda.dll library, installed and configured the Oracle client.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Tue 14 May 2013 12:00

Hello.
All our clients are working on "clean" PC. Today I ran the test from one of them. Error same, but in other iterations.
First pressing the button gives an error for the third time:
"Access violation at addess 013629C3 in module 'dbexpoda.dll'. Read of address 0175C000 i=3"
Second pressing the button gives an error immediately:
"Access violation at addess 013629C3 in module 'dbexpoda.dll'. Read of address 0175C000 i=1"
The third and subsequent pressing does not make mistakes.

2007 driver (dbexpoda.dll) works fine with no errors.
The bug had appeared in the driver 2012.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Wed 15 May 2013 08:55

Hello.
You have this test works, or gives an error?

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Wed 15 May 2013 14:12

Hello,

We cannot reproduce the problem on our servers and PCs. If you are able to open remote access to your Oracle server, we will try to reproduce the problem on your real server.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Mon 20 May 2013 15:21

Hello,
I sent you a dump of the database, which can be observed error.
Please, try to find the error.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Wed 22 May 2013 10:32

Hello,
do you found an error?
Whether to give the remote access?
Remote desctop or remote SQL?

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Wed 22 May 2013 14:32

Hello,

Unfortunately, we couldn't raise your dump due to errors. If you can open access to your server (ip, port, sid, login, password) for us, please send this data to my e-mail - and we will check this problem directly on your DB.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Fri 24 May 2013 13:04

Hello,
remote access is opened

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Mon 27 May 2013 08:23

Hello,

I've received your letter, however, when attempting to connect, Oracle returns the Unknown SID error. Please send the record from the tnsnames.ora file for connection to your server.

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Mon 27 May 2013 09:51

Hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible. Please don't close access to your server in order for us to be able to test the fix. As soon as we fix the problem, we will inform you.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Wed 05 Jun 2013 11:38

Hello,
have you finished testing? What are the results?
We would like to close the connection to the test server.

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Thu 06 Jun 2013 08:54

Hello,

We have reproduced the problem only on some PCs, therefore please don't close access in order for us to investigate the reasons for the error occurrence more deeply.

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

Re: Access violation at executing Stored Procedure

Post by AlexP » Fri 07 Jun 2013 09:19

Hello,

We have already fixed this problem, please send us your license number and e-mail to alexp*devart*com in order for me to send you the fixed version of dbExpress driver for Oracle.

alexer
Posts: 30
Joined: Tue 26 Dec 2006 14:07

Re: Access violation at executing Stored Procedure

Post by alexer » Thu 13 Jun 2013 13:33

My developer license number is CRDBO-00983.

[email protected]

Thank you in advance

Post Reply