This illustration describes using OCIBindByName() to associate placeholders with program variables. It shows one SQL statement: INSERT INTO emp VALUES (:empno, :ename, :job, :sal, :deptno). The call OCIBindByName() associates the placeholders in the SQL statement as follows:

Placeholder	:empno	:ename	:job	:sal	:deptno
Address	&empno	ename	job	&sal	&deptno
Data Type	integer	string	string	integer	integer
Length	sizeof(empno)	strlen(ename)+1	strlen(job)+1	sizeof(sal)	sizeof(deptno)