Re: Problem opening stored procedure that contains cursor

Bob Barrows [MVP] wrote:
Pier-Paolo wrote:
SET NOCOUNT ON

did not function !

In order to reproduce the error I think that is enough to create a
stored procedure that use a SQL CURSOR to create a temporary table.


I need more than that. A cursor on its own does not return records to
the client. I cannot reproduce your problem with simply the cursor
code.

I am suspecting your problem is related to the temporary table rather
than the cursor. You should try creating a test procedure that simply
creates a temp table without using the cursor and see if that produces
the same result.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: noise words, @@ERROR, and stop and resume indexing
    ... these words at the beginning before sending them to the cursor. ... Looking for a FAQ on Indexing Services/SQL FTS ... >>Create table Noise ... >>> 1) check noise words inside stored procedure ...
    (microsoft.public.sqlserver.fulltext)
  • Re: The most bizarre fix!
    ... Microsoft Office MVP ... THAT DARN BLINKING "PERIOD" CURSOR! ... The possibility doesn't seem to be mentioned in the help file, ...
    (microsoft.public.word.newusers)
  • Re: SQL stored procedure not working.
    ... If I do not use that, how can I get the total record count? ... >> I create a stored procedure and a asp page. ... Even if you could specify the cursor type there, ... > interested in the RETURN value, you do not need to use a Command object. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Case statement issue
    ... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Case statement issue
    ... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
    (microsoft.public.inetserver.asp.general)