xviii
15 OCI Relational Functions
Introduction to the Relational Functions..................................................................................... 15-2
Function Syntax........................................................................................................................... 15-2
Calling OCI Functions................................................................................................................ 15-3
Server Round-trips for LOB Functions.................................................................................... 15-3
Connect, Authorize, and Initialize Functions ............................................................................. 15-4
OCIConnectionPoolCreate() ..................................................................................................... 15-5
OCIConnectionPoolDestroy()................................................................................................... 15-8
OCIEnvCreate()........................................................................................................................... 15-9
OCIEnvInit().............................................................................................................................. 15-12
OCIEnvNlsCreate()................................................................................................................... 15-14
OCIInitialize()............................................................................................................................ 15-18
OCILogoff()................................................................................................................................ 15-21
OCILogon()................................................................................................................................ 15-22
OCILogon2().............................................................................................................................. 15-24
OCIServerAttach().................................................................................................................... 15-27
OCIServerDetach().................................................................................................................... 15-30
OCISessionBegin().................................................................................................................... 15-31
OCISessionEnd()....................................................................................................................... 15-35
OCISessionGet()........................................................................................................................ 15-36
OCISessionPoolCreate()........................................................................................................... 15-40
OCISessionPoolDestroy() ........................................................................................................ 15-44
OCISessionRelease()................................................................................................................. 15-45
OCITerminate()......................................................................................................................... 15-47
Handle and Descriptor Functions................................................................................................ 15-48
OCIAttrGet().............................................................................................................................. 15-49
OCIAttrSet()............................................................................................................................... 15-51
OCIDescriptorAlloc()............................................................................................................... 15-53
OCIDescriptorFree()................................................................................................................. 15-55
OCIHandleAlloc()..................................................................................................................... 15-57
OCIHandleFree() ...................................................................................................................... 15-60
OCIParamGet().......................................................................................................................... 15-62
OCIParamSet() .......................................................................................................................... 15-64
Bind, Define, and Describe Functions ........................................................................................ 15-66
OCIBindArrayOfStruct() ......................................................................................................... 15-67