ASP with SP out param type = cursor

• sinha_vivek

  Newbie

  Points: 3

  More actions

  July 16, 2002 at 11:24 pm

  #78710

  Hi,

  This might be more a ASP question than a SQL one but I'm hoping there's someone here who's either faced this problem or RTFM for someone else. Here goes....

  I have a stored procedure that returns a recordset and has one out parameter of cursor type -

  
  
  create procedure dbo.usp_GetSearchQueryColumnNamesCursor(
  
  @cReturnCursor cursor varying output)
  
  .....
  
  

  This needs to get invoked from another procedure as well as from an ASP. The ASP is only interested in the recordset while the calling procedure is only interested in the cursor. While I've got the first case down, I can't figure out how to call the proc from ASP. Specifically, I do not know what type to assign to the out param when invoking the procedure.

  Ideas (or whack on the head) would be appreciated.

  Thanks!

• Michael Levy

  Valued Member

  Points: 66

  More actions

  July 17, 2002 at 10:44 am

  #432904

  Can you make the CURSOR parameter optional. Then you wouldn't have to map a parameter to it when making the ADO call.

  -Mike

  Michael Levy

  ma_levy@hotmail.com

  
  Michael Levy
  ma_levy@hotmail.com