Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    23

    Unanswered: HELP! " the table schema changed after the cursor was declared"

    I have a DTS package working from backend and command line. Then I did an enhancement. It works from backend but not from command line. The error says:

    Step Error Description:Could not complete cursor operation because the table schema changed after the cursor was declared.

    But I don't see "table schema" change?!! Any idea?

    Thanks,

    Lili
    DTS -> Oracle

  2. #2
    Join Date
    Dec 2002
    Location
    San Diego
    Posts
    1

    Re: HELP! " the table schema changed after the cursor was declared"

    Originally posted by lili3000
    I have a DTS package working from backend and command line. Then I did an enhancement. It works from backend but not from command line. The error says:

    Step Error Description:Could not complete cursor operation because the table schema changed after the cursor was declared.

    But I don't see "table schema" change?!! Any idea?

    Thanks,

    Lili
    I ran in to the same problem. As it turned out I was running the application at 1:00 am to process credit card transaction (This application is a batched response from shipper) Anyway. I had inadvertly schedule maintence during this time. The problem was resolved by moving the Maintence time.

    I hope this helps.

    Terry

Posting Permissions

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