Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    78

    Unanswered: Prepare Statment in SP, need help!

    Hello experts,

    I keep getting
    CLI0115E Invalid cursor state. SQLSTATE=24000
    error from one of my SP.

    I use prepare statement for the cursor, and the same statement can be executed correctly and show me results in command center. But just doesn't have any result from development center, although it does not have any run time error message.

    I'd appreciate any suggestions.

  2. #2
    Join Date
    Jul 2003
    Posts
    78

    Re: Prepare Statment in SP, need help!

    Hi,

    just let you all know, I fixed it. it is seems stupid, I forgot declare cursor WITH RETURN. but in AS400 it doesn't matter at all.

    Originally posted by christine2003
    Hello experts,

    I keep getting
    CLI0115E Invalid cursor state. SQLSTATE=24000
    error from one of my SP.

    I use prepare statement for the cursor, and the same statement can be executed correctly and show me results in command center. But just doesn't have any result from development center, although it does not have any run time error message.

    I'd appreciate any suggestions.

Posting Permissions

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