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)