Page 1 of 1
UniStoredProc Prepare raise AV
Posted: Sat 16 Feb 2013 13:15
by malinsky
Hello,
after upgrade from 4.5.10 to 4.6.
12 cannot prepare TUniStoredProc at runtime.
AV is raised...
Delphi 2010 and Delphi XE2 the same error.
Code: Select all
with UniStoredProc1 do
begin
if not Prepared then
Prepare; //====>>>> 'Access violation at address 005AD020 in module 'Project1.exe'. Read of address 000000F8'.
//...
ExecProc;
end;
What is wrong?
Thanks Pavel;
Re: UniStoredProc Prepare raise AV
Posted: Mon 18 Feb 2013 14:37
by AndreyZ
Hello,
Please specify the following:
- database server you are working with (SQL Server, Oracle, etc.);
- the script to create your stored procedure.
Re: UniStoredProc Prepare raise AV
Posted: Mon 18 Feb 2013 14:56
by malinsky
Hello,
- Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (Intel X86)
Aug 22 2012 15:16:00
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
Code: Select all
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE dbo.SP_INSERTSELECTEDUID_TS
( @session_uid uniqueidentifier,
@selected_uid uniqueidentifier)
AS
BEGIN
insert into TS_VYBRANEZAZNAMY (session_uid, selected_uid)
values (@session_uid, @selected_uid);
END
-
Re: UniStoredProc Prepare raise AV
Posted: Mon 18 Feb 2013 15:08
by AndreyZ
Thank you for the information. We reproduced the problem and the investigation is in progress. We will notify you when we have any results.
Re: UniStoredProc Prepare raise AV
Posted: Mon 18 Feb 2013 17:28
by malinsky
Additional information...following servers have the same symptoms
- Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (Intel X86)
Jun 11 2012 17:46:13
Copyright (c) Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
- Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Re: UniStoredProc Prepare raise AV
Posted: Wed 20 Feb 2013 13:29
by AndreyZ
We have fixed this problem. This fix will be included in the next UniDAC build.
Re: UniStoredProc Prepare raise AV
Posted: Thu 21 Feb 2013 11:51
by AndreyZ
UniDAC with this fix is already available. Registered users can download it from Registered Users' Area. UniDAC Trial Edition is available at
http://www.devart.com/unidac/download.html
Re: UniStoredProc Prepare raise AV
Posted: Thu 21 Feb 2013 12:31
by malinsky
Version stay on 4.6.12 ?
Re: UniStoredProc Prepare raise AV
Posted: Thu 21 Feb 2013 14:33
by AndreyZ
malinsky wrote:Version stay on 4.6.12 ?
Yes.
Re: UniStoredProc Prepare raise AV
Posted: Thu 21 Feb 2013 17:32
by malinsky
OK. After new download 4.6.12 seems be problem fixed. Tested in D2010/MSSQL2008.
Testing in DXE2 and MSSQL2008R2 or MSSQL2012 I will be tested later...
Thanks
Re: UniStoredProc Prepare raise AV
Posted: Thu 21 Feb 2013 18:07
by malinsky
Testing in other Delphi versions and DB servers seems be also OK.
PMal
Re: UniStoredProc Prepare raise AV
Posted: Fri 22 Feb 2013 08:38
by AndreyZ
Thank you for your confirmation.