Re: [Emerald] Error in stored procedure

Josh Hillman ( (no email) )
Mon, 14 Feb 2000 17:00:11 -0500

From: Robert H. Clugston <robert@csnsys.com>
> Running the stored procedure "UpdateCalls_AccountID" I get the following
> error:
> "Cursorfetch: Maximum length of '@username' is incompatible with that of
> selected column in the cursor (Message 16923)"
>
> Any ideas on how to fix this?

In ISQL, type the following to find out what "length" the Login column is:
sp_help SubAccounts
Then go into the stored procedure and change the following line to reflect
that number:
DECLARE @username varchar(32), @acctid int

In other words if "sp_help subaccounts" returns a length of 16 for Login,
then change the above line to read:
DECLARE @username varchar(16), @acctid int

Or, if you're using SQL 7, you can change the length of the
SubAccounts.Login column to 32...

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart