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)