[ad_1]
my professor asked us to do a project using PHP and SQL (Oracle) and I've never done PHP before in class or outside of it. I keep getting an error on the execute line that says my inputs are not correct. Is there something I'm doing wrong in the input area, or is there something else wrong. I'm trying to execute a stored procedure.(Error code is ORA-06550).
function makeReservation($conn, $roomNo, $custID, $cardNo, $startDate, $startTime, $endDate, $endTime)
$procedure = oci_parse($conn, 'BEGIN makeReservation(:roomNo, :custID, :cardNo, TO_DATE(:startDate, 'month dd YYYY'), :startTime, TO_DATE(:endDate, 'month dd YYYY'), :endTime); END;');
oci_bind_by_name($procedure, ':roomNo', $roomNo);
oci_bind_by_name($procedure, ':custID', $custID);
oci_bind_by_name($procedure, ':cardNo', $cardNo);
oci_bind_by_name($procedure, ':startDate', $startDate);
oci_bind_by_name($procedure, ':startTime', $startTime);
oci_bind_by_name($procedure, ':endDate', $endDate);
oci_bind_by_name($procedure, ':endTime', $endTime);
oci_execute($procedure);
[ad_2]
لینک منبع
