note 45067 deleted from function.ocibindbyname by sixd

Note Submitter: jriley at gamesville dot com ---- To select a value from DUAL, use a length of -1. DUAL is defined as a table of VARCHAR2(1). ex: $stmt = OCIParse($conn, "select :VAR from DUAL"); ocibindbyname($stm, ":VAR", &$Var, -1); For a query using LIKE, put the percent signs in the variable definition and skip the single quotes you would normally put around the regex in SQL. ex: $ename = "%{$ename}%"; $stmt = OCIParse($conn, "select empno from emp where ename like :ename"); OCIBindByName($stmt, ":ename", $ename, 32); Adding single quotes around :ename in $query will cause an "ORA-01036: illegal variable name/number" error. Adding them in $ename will add single quotes to the search string.