da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Parameters and TOCIQuery

Forum List » NCOCI8 » General English

alexv
User

Fresh Boarder

Posts: 2

Karma: 0

Parameters and TOCIQuery

Posted: 2000/08/22 13:05

в TOCIQuery.SQL я пишу запрос с параметрами, и описываю типы параметров.
После заполнения параметров и открытия запроса в Оракл передается запрос с именами (:имя), а не значениями параметров.

Diman

Admin

Posts: 1495

Karma: 19

RE: Parameters and TOCIQuery

Posted: 2000/08/22 14:12

Hi Alex !

Oracle server is aware about such SQL construction as ":name". He knows that, it is parameter. Oracle server receive SQL query text and parameter values separately. During query execution Oracle RDBMS use received parameter values.

So, that is right functionality

PS: Please use english for you postings into NCOCI8 forum. If it is complex to you, let me know, and i will answer on russian.

Forum List » NCOCI8 » General English