Dynamic Generation of Binds and Defines in OCI
NAVAL OCEAN SYSTEMS CENTER SAN DIEGO CA
Pagination or Media Count:
A C structure and the ORACLE Call Interface OCI describe function, ODSC, can be combined to provide a method of dynamically building OCI bind and define statements for various SQL statements. The resulting program requires no special knowledge about any tables or columns and is unaffected by database alterations. This paper describes the construction of the C structure, the usage of the OCI functions ODSC, ODFINE, and OBNDRV, and the procedure of combining them into a finished program.
- Computer Programming and Software