da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: TOCIUpdateSQL

Forum List » NCOCI8 » General English

alexv
User

Fresh Boarder

Posts: 2

Karma: 0

TOCIUpdateSQL

Posted: 2000/08/10 12:33

I have procedures in Oracle:

CREATE PROCEDURE INS_
( ID_ NUMBER,
TXT_ CHAR(10))
BEGIN
INSERT INTO TABLE
VALUES (ID_, TXT_);
END INS_;

CREATE PROCEDURE UPD_
( ID_ NUMBER,
TXT_ CHAR(10))
BEGIN
UPDATE TABLE
SET TXT:=TXT_
WHERE ID=ID_;
END UPD_;

CREATE PROCEDURE DEL_
( ID_ NUMBER)
BEGIN
DELETE FROM TABLE
WHERE
TABLE.ID=ID_
END DEL_;

How I can to use this procedure in TOCIUpdateSQL's propeties:
SQLDelete, SQLUpdate and SQLInsert

Diman

Admin

Posts: 1495

Karma: 19

RE: TOCIUpdateSQL

Posted: 2000/08/10 19:44

Hi Alex !

I done example. Please download it from http://www.geocities.com/ncoci8/Download/Other/ProcUpd.zip. It have very simple demo about , how implement your issue.

PS: If you will have some problems with download of archive, let me know.

Diman

Admin

Posts: 1495

Karma: 19

RE: TOCIUpdateSQL

Posted: 2000/08/10 20:10

Forget say, how to optimize it... NCOCI8 can do a lot of interesting things

Turn off TOCIUpdateSQL.UpdateChangedFields. If this property is True, then NCOCI8 during each update/insert unprepares correspondent query and build it using current knowledges about data - what fields are null and what are not. In case of static stored proc calls, there are no difference in that case - parameters list is fixed. So, if you will turn off UpdateChangedFields, NCOCI8 will not unprepare queries. Some gains in performance

Forum List » NCOCI8 » General English