UniStoredProc Prepare raise AV

[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;

[AndreyZ]

Hello,

Please specify the following:
- database server you are working with (SQL Server, Oracle, etc.);
- the script to create your stored procedure.

[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

-

[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.

[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)

[AndreyZ]

We have fixed this problem. This fix will be included in the next UniDAC build.

[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

[malinsky]

Version stay on 4.6.12 ?

[AndreyZ]

Version stay on 4.6.12 ?

Yes.

[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

[malinsky]

Testing in other Delphi versions and DB servers seems be also OK.
PMal

[AndreyZ]

Thank you for your confirmation.