Page 1 of 1
Access Violation using TORAStoredProc
Posted: Wed 22 Apr 2009 14:51
by rkiguti
I updated my ODAC component version from 5.7 to 6.8 for Delphi 6 and now I get an access violation when I use the TOraStoredProc.
The error occurs when I set the property StoredProcName.
Code: Select all
sp := TORAStoredProc.Create(nil);
sp.Session := MySession;
sp.StoredProcName := 'Procedure'; //Access Violation
sp.PrepareSQL;
sp.ExecProc;
Regards,
Kiguti
Posted: Thu 23 Apr 2009 08:49
by Plash
We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.
Posted: Thu 23 Apr 2009 14:46
by rkiguti
It's so strange, I did a small sample and I can't reproduce the problem, but in my main application occurs the error.
The error raises when I call the Stored Procedure in the second time.
It's difficult to find the problem because I don't have the source from ODAC. And the old version works very good.
I updated because we are using Oracle 11g.
Posted: Mon 27 Apr 2009 07:27
by Plash
Try to extract a part of your main application and make an examle of it.
Posted: Wed 10 Jun 2009 14:56
by rkiguti
I reproduce the problem with a small application.
The error occurs when I use any stored procedure several times.
There are two situations, the first code raise the erros easier than the second.
Code: Select all
sp := TORAStoredProc.Create(nil);
sp.Session := MySession;
for i := 0 to 10 do
begin
sp.StoredProcName := 'Procedure1';
sp.PrepareSQL;
sp.StoredProcName := 'Procedure2';
sp.PrepareSQL;
end;
sp.Free;
Code: Select all
for i := 0 to 10 do
begin
sp := TORAStoredProc.Create(nil);
sp.Session := MySession;
sp.StoredProcName := 'Procedure1';
sp.PrepareSQL;
sp.Free;
sp := TORAStoredProc.Create(nil);
sp.Session := MySession;
sp.StoredProcName := 'Procedure2';
sp.PrepareSQL;
sp.Free;
end;
Posted: Thu 11 Jun 2009 06:12
by Plash
We still cannot reproduce the problem. Please send us the complete sample including Delphi project and script for creating the stored procedures.
Posted: Thu 11 Jun 2009 14:36
by rkiguti
Ok, I will send a complete sample. What is your email?
Posted: Fri 12 Jun 2009 06:26
by Plash
odac*devart*com
Posted: Mon 15 Jun 2009 20:48
by rkiguti
I send to you a small application.
I have the same problem when I use the component DataAbstract from RemObjects. It creates an instance of TOraStoredProc.
Posted: Mon 22 Jun 2009 12:12
by rkiguti
I upgrade to the version 6.80.0.47, and the same error occur.
Posted: Tue 23 Jun 2009 08:12
by Plash
We have reproduced and fixed this problem. The fix will be included in the next build of ODAC.