da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Work with open cursors

Forum List » NCOCI8 » General English

Viking
User

Fresh Boarder

Posts: 7

Karma: 0

Work with open cursors

Posted: 2000/06/27 12:17

Можно ли работать с открытыми курсорами как в DAO? Если нет - то планируется ли такая работа?

Diman

Admin

Posts: 1482

Karma: 19

RE: Work with open cursors

Posted: 2000/06/27 13:14

Привет !

хмм... а как оно в DAO ? Открытый курсор в NCOCI8 это наследник TOCIDataSet в состоянии Active (это наиболее похожий аналог). То есть, в самом простом случае открытый курсор это TOCIQuery с Active = True.

Viking
User

Fresh Boarder

Posts: 7

Karma: 0

RE: Work with open cursors

Posted: 2000/06/28 07:19

Hi!
In DAO - I open cursor in one script, work with it in second script (use it handle), and close it in last script (equ PL-SQL program)

Diman

Admin

Posts: 1482

Karma: 19

RE: Work with open cursors

Posted: 2000/06/28 11:10

Hi !

1) In client programm, that uses NCOCI8, you can share TOCIDataSet as you want, of course.
2) Also you can submit cursor (closed) from client to server, open it on server and return it to client. For that see PL/SQL parameters with type of REF CURSOR and NCOCI8 demo RefCursor.
3) You can share cursors with many ways in PL/SQL programms.

Also, you can take a look on DBMS_SQL package, that allows you work with dynamic SQL in PL/SQL. This package works with handles, that you can share as you want, but only inside session. Also client software (and NCOCI8) does not work with it. On client this handles will be see as integers.

Forum List » NCOCI8 » General English