Access Violation using TORAStoredProc

rkiguti · Post by **rkiguti** » Wed 22 Apr 2009 14:51

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

Plash · Post by **Plash** » Thu 23 Apr 2009 08:49

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.

rkiguti · Post by **rkiguti** » Thu 23 Apr 2009 14:46

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.

Plash · Post by **Plash** » Mon 27 Apr 2009 07:27

Try to extract a part of your main application and make an examle of it.

rkiguti · Post by **rkiguti** » Wed 10 Jun 2009 14:56

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;

Plash · Post by **Plash** » Thu 11 Jun 2009 06:12

We still cannot reproduce the problem. Please send us the complete sample including Delphi project and script for creating the stored procedures.

rkiguti · Post by **rkiguti** » Thu 11 Jun 2009 14:36

Ok, I will send a complete sample. What is your email?

Plash · Post by **Plash** » Fri 12 Jun 2009 06:26

odac*devart*com

rkiguti · Post by **rkiguti** » Mon 15 Jun 2009 20:48

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.

rkiguti · Post by **rkiguti** » Mon 22 Jun 2009 12:12

I upgrade to the version 6.80.0.47, and the same error occur.

Plash · Post by **Plash** » Tue 23 Jun 2009 08:12

We have reproduced and fixed this problem. The fix will be included in the next build of ODAC.