Hi,
I'm trying to get an result from a query. I use Oracle and PHP. When I use OCIBindByName I get an error: Warning: OCIBindByName: ORA-01036: illegal variable name/number.
this is my code:
<?PHP
$usr = "medusa_p";
$pwd = "medusa";
$sid = "TSDATA.DPSOFT";
$conn = OCILogon ($usr, $pwd, $sid);
$query = "select min(mederwerkpersid) as MEDID from mederwerker";
$stmt = OCIParse($conn, $query);
OCIBindByName($stmt,"MEDID", &$result);
OCIResult($stmt,$result);
echo $result;
ocilogoff($conn);
?>