Post reply

API_CURSOR & sp_cursorfetch

  • July 6, 2009 at 5:42 am

    #134034

    Hi,

    Can any one explain what is the use of FETCH API_CURSOR and EXEC sp_cursorfetch

    I have a code in one application like this

    FETCH API_CURSOR000000000000000B

    exec sp_cursorfetch 180150003,16,1,1

    i trace this from our application, after this statement i'm getting message like

    Your session has expired, please log in again

    thanks in advance

    Viji

  • July 6, 2009 at 8:53 pm

    #1020833

    What application are you tracing? There are several third-party applications that use server-side cursors in this fashion, one such application is PeopleSoft.

  • July 6, 2009 at 9:04 pm

    #1020835

    Thanks Lynn Pettis,

    that is a web application. I use sql server 2005 and ASP.

    the same code works well with one set of DB. the same code doesnot work with another database which has the same set of tables but with less amount of data.

    regards

    Viji

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply