Environment:
W2K server and SQL Server 2000 with ColdFusion Server 5
Having a bit of a problem with a stored proc once I added a cursor as an output param.
Error is: "Operand type clash: char is incompatible with cursor"
This is the SP declaration:
CREATE PROCEDURE [dbo].[spBonusTotalAllAssocByMonth]
@dStartDate datetime, @dEndDate datetime, @curRS CURSOR VARYING OUTPUT
AS
.
.
This is the CF param for the Cursor:
<cfprocparam type = "Out" CFSQLType = "CF_SQL_REFCURSOR"
variable = "curRS" dbVarName="@curRS">
What am I doing incorrectly?
W2K server and SQL Server 2000 with ColdFusion Server 5
Having a bit of a problem with a stored proc once I added a cursor as an output param.
Error is: "Operand type clash: char is incompatible with cursor"
This is the SP declaration:
CREATE PROCEDURE [dbo].[spBonusTotalAllAssocByMonth]
@dStartDate datetime, @dEndDate datetime, @curRS CURSOR VARYING OUTPUT
AS
.
.
This is the CF param for the Cursor:
<cfprocparam type = "Out" CFSQLType = "CF_SQL_REFCURSOR"
variable = "curRS" dbVarName="@curRS">
What am I doing incorrectly?