1 Reply Latest reply on Jan 17, 2011 9:03 AM by ChrisJenkins-Oracle

    Function sequence error

    user12852808
      Hi,

      I've encounter one error when executing a stored procedure in TimesTen 11.2 called "Function sequence error".

      [TimesTen][TimesTen 11.2.1.6.1 ODBC Driver]Function sequence error*** ODBC Error/Warning = S1010, Additional Error/Warning = 0[TimesTen][TimesTen 11.2.1.6.1 ODBC Driver]Invalid cursor number*** ODBC Error/Warning = S1000, Additional Error/Warning = 0*** ODBC Error/Warning = 00000, Additional Error/Warning = 0*** ODBC Error/Warning = 00000, Additional Error/Warning = 0[TimesTen][TimesTen 11.2.1.6.1 ODBC Driver]Function sequence error*** ODBC Error/Warning = S1010, Additional Error/Warning = 0*** ODBC Error/Warning = 00000, Additional Error/Warning = 0

      The matter is that this error happens rarely, not frequently. The stored proc is executed many times without error but sometimes it occurs and makes my program crashes :((.

      Pls help to figure out. It is very critical.

      Thanks,

      Dac
        • 1. Re: Function sequence error
          ChrisJenkins-Oracle
          The usual cause of this is the fact that cursor behaviour in TimesTen is different to that in oracle. In TimesTen executing a commit or a rollback will close all open cursors on the connection where that operations is executed. A subsequent attempt to use (e.g. fetch from) such a cursor will typically result in this type of error.

          Could it be that under some circumstances the PL/SQL logic, or the application logic that calls it, may have executed a commit or rollback which has closed cursors and then the code has subsequently tried to use one of those cursors without re-opening it?


          Chris