like we do it with oracle
Code: Select all
$query="BEGIN BEGIN WEB_UTILS_PKG.UPDATE_EVENT_RESERVATION ('$company','$xyz,'$ev_id',TRUNC(TO_DATE('$ev_date', 'DD-MON-YY')),'$ev_no','Y','Y',:V_RESERVATION_STATUS,:V_SEAT_NUMBER); END; END;"Code: Select all
OCIBindByName($stmt, ":V_RESERVATION_STATUS", $RESERVATION_STATUS, 1);
OCIBindByName($stmt, ":V_SEAT_NUMBER", $SEAT_NO, 6);Dude