I would like to print the week day after
to receive a complete date in the format: dd/mm/yyyy
using oracle
i write this code but i get the error:
Warning: ocibindbyname(): OCIBindByName: ORA-01036: illegal variable name/number
Warning: ociexecute(): OCIStmtExecute: ORA-01858: was located a not-number caracter where was expected a number
Warning: ocifetchstatement(): OCIFetchStatement: ORA-24374: define not done before fetch or execute and fetch in
if( isset($POST["DATA_OCORRENCIA"]) )
{
print("<br>$POST[DATA_OCORRENCIA]<br>");
$cmdstr_diasemana = "SELECT ".
"TO_CHAR ( ( TO_DATE(':data_verbal', 'DD/MM/YYYY' )), 'DAY') ".
"AS data_semana FROM dual";
$parsed_diasemana = ociparse($db_conn, $cmdstr_diasemana);
OCIBindByName($parsed_diasemana, ":data_verbal", $_POST[DATA_OCORRENCIA], 10);
ociexecute( $parsed_diasemana );
$nrows_diasemana = ocifetchstatement( $parsed_diasemana, $results_diasemana );
for ( $i = 0; $i < $nrows_diasemana; $i++ ) {
echo "Dia ". $results_diasemana[data_semana][$i];
}
print $cmdstr_diasemana;
OCIFreeStatement( $cmdstr_diasemana );
OCILogoff( $db_conn );
}
