Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
AV in EDBMgr Stored Procedure |
Fri, Feb 15 2008 8:12 AM | Permanent Link |
Robin Joseph | Tim
EDBManager 1.08 B1 (Unicode) Remote connection to Unicode Server 1.08 B1 Executing the following stored procedure: BEGIN DECLARE TestCursor CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT CAST("Note Clob" as VarChar(500)) FROM "EDB Test Table"'; OPEN TestCursor; END Where "Note Clob" is a CLOB column gives an AV in the EDBManager The same procedure under Local mode runs Ok I assume for the same reason running the VS2008 program using the same procedure gives an exception Object reference not set to an instance of an object. at the line DataAdapter.Fill(EDBDataTable); Regards Robin Joseph |
Fri, Feb 15 2008 3:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robin,
<< Where "Note Clob" is a CLOB column gives an AV in the EDBManager The same procedure under Local mode runs Ok >> Yep, the computed column is not being compiled properly on the remote session side. I'll have a fix available shortly. I also noticed in the process of evaluating this that the error line and column numbers are not being returned properly for remote sessions either. << I assume for the same reason running the VS2008 program using the same procedure gives an exception Object reference not set to an instance of an object. at the line >> Yes, that would account for it. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 15 2008 3:49 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robin,
BTW, the workaround in this case is to use an insensitive result set, like this: BEGIN DECLARE TestCursor INSENSITIVE CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT CAST("Note Clob" as VarChar(500)) FROM "EDB Test Table"'; OPEN TestCursor; END The default is a sensitive cursor, and that is what is having the issue. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 15 2008 5:22 PM | Permanent Link |
Robin Joseph | Tim
It still AV's with the insensitive Cursor - I can wait for the fix to be released however. Regards Robin "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Robin, BTW, the workaround in this case is to use an insensitive result set, like this: BEGIN DECLARE TestCursor INSENSITIVE CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT CAST("Note Clob" as VarChar(500)) FROM "EDB Test Table"'; OPEN TestCursor; END The default is a sensitive cursor, and that is what is having the issue. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Feb 16 2008 11:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robin,
<< It still AV's with the insensitive Cursor - I can wait for the fix to be released however. >> You're right. It doesn't AV here, but it is still returning a sensitive cursor, which is why it is probably AVing still there. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |