Devart Forums

Hello,

I have a strange AV error while executing a stored procedure. The procedure starts,it's pending on SQL Monitor, but I get a huge AV ERROR. And it's not a simple AV, because it goes into an infinite loop, the application does not responds anymore. I have to kill the process with task manager.
I do not know, what's happened, it worked fine before. The stranger it can be, the procedure is called perfectly, I see the inserts and updates in the database, what have to do. But the returned parameter values are not shown in the SQL Monitor.
If I comment out the call of this procedure, the application works fine, other procedures are called perfectly, but after that, 10-20 procedures later, and other procedure call fails again, with the same error.
We are using Delphi 2010 and ODAC 6.90. We tried to upgrade to Odac 9.0, but we also have problems, with stored procedures.http://forums.devart.com/viewtopic.php?f=5&t=27177
Can you help us with something more detailed diagnostic tool, which can show the exact location of the error?

https://picasaweb.google.com/1076294901 ... 6496393234

https://picasaweb.google.com/1076294901 ... 1989117362

https://picasaweb.google.com/1076294901 ... 5362728226

Hello,


The problem discussed in the http://forums.devart.com/viewtopic.php?f=5&t=27177 topic has been already fixed, this fix will be included to the next build planned for this month.
Please try to reproduce the problem with a stored procedure in the new demo version of ODAC (in a new application) and let us know the result. If the problem repeats, we will try to fix it till the new build.

"If the problem repeats,"
I cannot reproduce the problem with the 9.0 trial, because I run into my other problem with wrong number or type of parameters
And this "wrong number" error message appears long before the other procedure (which causes the AV error).

http://forums.devart.com/viewtopic.php?f=5&t=27177

Hi,

When you could send us the fixed, because we can't ship the new product version to our customer's, and they will kill us !
They are very urgent !
Please help us !

Sándor Lencsés
CEO

We can send you a build with the fix of this bug if you provide us your registration information (license number) and the IDE version you are using. Please provide this information by the following form: http://www.devart.com/company/contactform.html (do not post the license number on the forum).

I've found a very similar problem here.

"invalid pointer operation" on changing SQL for 5th time"
http://forums.devart.com/viewtopic.php?t=19861

I don't know if it is the same or not, but maybe .

Hello,

Please describe the steps leading to the problem in more details.

Sorry, I cannot give you a sample, because this problem exists only in some of our very complex forms.
There is nothing special, only the amount of data on the screen. Two datasets with more than 500 fields, and dozens of stored procedures to be executed before and after posting these records.
When we try to post the datasets, one of the stored procedure calls stops with Access vioaltion. The strange is, that the stored procedure is called perfectly (I see the changes in the database), but the output variables does not read back. DB Monitor says it is pending, and the AV error message is on the screen, as you can see it on my first post.

Hello,

Unfortunately, we cannot reproduce the problem. If the problem occurs under definite conditions only, please try to create a small application that would explicitly demonstrate the problem, and send it to us to alexp*devart*com.

P.S. We cannot fix the problem without reproducing it.