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 |
| Datatype | integer | string | string | integer | integer |
| Length | sizeof(empno) | strlen(ename)+1 | strlen(job)+1 | sizeof(sal) | sizeof(deptno) |