Re: Cursors and DTS

Fixed the problem, my own fault, it was a problem with a SET DATEFORMAT
statement which I had (Stupidly) placed after the cursor had been declared.
Placing it before the declaration of the cursor fixed the problem

Mark

"Mark" <mark@xxxxxxxxxxxxxxx> wrote in message
news:O6kCBJVIGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
> Hi, I am using a cursor inside a stored procedure to do some complex work
> on each row in a table.
>
> Looking at the execution plan everything looks fine (Always worry about
> cursors!!) and the Stored Procedure runs fine if I call it via Query
> Analyser.
>
> When I go to run the stored procedure from a DTS package (exec
> MyStoredProcedure) I receive the following error message..
>
> "The cursor is not open. Could not complete cursor operation because the
> set operations have changed since the cursor was declared"
>
> Any ideas how I can get around this??
>
> TIA
> Mark
>


.

Relevant Pages

  • Re: plsql. Test API?
    ... >PROCEDURE query ( ... REF CURSOR. ... Also your parameter declaration is syntactically not correct (as you ... type curtype is ref cursor; ...
    (comp.databases.oracle.misc)
  • Re: Dealing with a new codebase
    ... Once it had finished updating, I felt like I was watching a movie every time I moved the cursor or typed anything. ... Most importantly is that when you put the cursor on a symbol, the bar at the top shows the declaration. ... If you hover over a symbol, the down arrow appears, clicking it gives you a menu with "Find References" in it. ...
    (microsoft.public.vc.mfc)
  • Re: Is there a cleaner way to do this?
    ... The cursor declaration uses the same SELECT ... SET sentmail = null ... > update SENDCALL70C ...
    (microsoft.public.sqlserver.programming)
  • FAST_FORWARD Cursor Slower than default?
    ... I am trying to optimize a stored procedure that uses cursors ... Each row in the data has a column of dynamic sql that ... FAST_FORWARD to the declaration of the cursor actually causes it to ...
    (microsoft.public.sqlserver.programming)
  • Re: Very strange problem.
    ... >Can I use "for update" in the declaration of a cursor? ... When I commit records after delete 3000 rows, ... If this is a disk space issue, ...
    (comp.databases.oracle.server)