I'm not sure what the "varying output" bit is for in your parameter declarations....I've never seen or used it. What is the line number that it is erroring on?
------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Emily C. Grossman [mailto:[EMAIL PROTECTED]] Sent: 29 October 2001 14:39 To: CF-Talk Subject: QUESTION: SQLServer cursors vs Oracle REF cursors.. I'm working on my first SQLServer SPROC app and I'm trying to create the equivalent of an Oracle referential cursor in my sproc but am running up against this error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: char is incompatible with cursor In Oracle I simply create a pointer to my ref cursor package and output the results. I have no probs getting it to run, error-free but now I am stumped. Here's my sproc -- perhaps someone has some insight: CREATE PROCEDURE dbo.testProc @curr int, @undef cursor varying output as declare @currid int, @currtitle varchar(2000) declare undef cursor for select a.ID, a.TITLE from vw_CONTENT_status a, tbl_fpContent b where a.status like 'Live' and b.id=a.id and a.id=@curr order by b.pos OPEN undef while @@fetch_status = 0 begin fetch next from undef into @currid, @currtitle end close undef deallocate undef GO I'm accessing this w/ CFSTOREDPROC and resultset but am getting this error. I can find nothing in the SQL docs about referential cursors.. Any insights appreciated! thanks, -e ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
