Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using an Output Cursor in a Stored Procedure

Status
Not open for further replies.

topry

Programmer
Aug 18, 2001
13
0
0
US
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 = &quot;Out&quot; CFSQLType = &quot;CF_SQL_REFCURSOR&quot;
variable = &quot;curRS&quot; dbVarName=&quot;@curRS&quot;>

What am I doing incorrectly?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top