Home » Developer & Programmer » Precompilers, OCI & OCCI » Regarding Scrollable cursor
Regarding Scrollable cursor [message #94460] Fri, 26 November 2004 01:43
Messages: 38
Registered: May 2001
i have a doubt regarding SCROLLABLE CURSOR in pro*c.
In our system we implement scrolling as follows.
suppose we have 25 rows to process and our page size is 10,
we use primary keys columns to identify till which extent we
have processed records.
I am writing a new program where we have PK with 5 columns
and the query is also very complicated. Hence i decided to
check with new feature SCROLLABLE cursor in pro*c (oracle 9i).
Here i will be finding till which record i processed earlier
and use FETCH ABSOLUTE :rowsProcessed to proceed further.With this approach, i can have only one query and fetch data from any absolute number of records.

My concern is whether this approach will impact on the performance of the sql.

Pls let me know your comments/suggestions.

Thanks in advance.
Previous Topic: Problem in compiling Pro*C program
Next Topic: sqlcxt error in Pro*c under turboc in windows
Goto Forum:

Current Time: Mon Nov 23 16:57:38 CST 2020