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

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

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

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

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