Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Red face Unanswered: Error : select : [IBM][OCI Driver] CLI0125E Function sequence error. SQLSTATE=HY010

    We in our application trying to migrate the database and code from Oracle(10g) to Db2(10.1).
    In the code we are using DB2CI for interacting with db2.
    In the process we are using the cursors in the application.
    as part of the cursor execution the cursor is able to fetch few rows of data and
    it is hanging up and giving the error
    Error : === select : [IBM][OCI Driver] CLI0125E Function sequence error. SQLSTATE=HY010

    we could not figure out what is the problem
    the same code with Oracle with OCi works fine ..

    Any pointers on this will be of great help

    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Clearly, the error is on line 117.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Please publish the DB2 version/release/fixpack and the platform OS you are using.

    Please publish the CREATE FUNCTION statement, and the way to call(or use) the function.

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Another possibility might be incorrect execution sequence of OPEN, FETCH and COLSE cursor.

Posting Permissions

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