Re: Problem opening stored procedure that contains cursor

Pier-Paolo wrote:
Inside the stored procedure I use CURSOR to creeate a temporary table.

After I use the temporary table that I have created in JOIN with
other table in order to have a resultset as a result

I have just inserted on the top of the sored procedure the istruction

SET NOCOUNT ON


And did that help? if not, provide a repro script (www.aspfaq.com/5006)
so we can attempt to reproduce the problem.

--
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: Problem opening stored procedure that contains cursor
    ... Pier-Paolo wrote: ... The aspfaq article i cited explains how to generate CREATE TABLE and ... I was needing to see the rest of the procedure ... ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: ASP/ADO: Return a value from a Stored Procedure
    ... Any resultset is large compared to the data it contains, ... resultset across processes into a COM recordset. ... a web server, an application is not working in isolation. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: JSP ORACLE CONNECTIVITY
    ... newsgroup, so other can benefit from or object to the answers... ... executeUpdate doesn't return a ResultSet and it shouldn't. ... or 0 for SQL statements that return nothing. ... // Bjorn A ...
    (comp.lang.java.databases)