PHP Manual . ... 3.0.7 - 3.0.18 only, PHP 4 >= 4.0.0) OCIDefineByName -- Use a PHP variable for the define-step during a SELECT . int OCIDefineByName ( int stmt, string Column-Name, mixed variable [, int type]) . OCIDefineByName() uses fetches SQL-Columns into user-defined PHP-Variables. ... php /* OCIDefineByPos example thies@thieso.net (980219) */ $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"select empno, ename from emp"); /* the define MUST be done BEFORE ociexecute! ...