Stored Procedures

Results 1 to 2 of 2

Thread: Stored Procedures

  1. #1
    Akram Guest

    Default Stored Procedures

    Hi everybody,<BR><BR>Infrastructure : Windows NT 4,Option Pack 4 (IIS4 and MTS 2),SQL 6.5<BR><BR>A stored procedure has been created in the database, with <BR>various IF conditions and select statements within IF blocks.<BR>To start with, i&#039m calling an MTS component from the ASP file. Within the MTS Component, i&#039m invoking a Stored procedure (using normal recordset object)<BR>eg.<BR><BR>str = "exec sp_pmload" & "P", "," & "R"<BR>rs1.Open str,conn,1,3<BR><BR>Whenever I try to execute the component, it displays the following error in my page..<BR><BR>"Cannot open a cursor on a stored procedure that has anything other than a single select statement in it"<BR><BR>Has anyone come across this error?? <BR><BR>Tx in advance<BR><BR>Akram<BR>

  2. #2
    Ed Guest

    Default RE: Stored Procedures

    Try doing it without the exec. Also, you need a space after sp_pmload.<BR><BR>str = "sp_pmlod " & "P"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts