Pro*C Assistance
From: Paul Mickel <mickel_at_OES.ORST.EDU>
Date: 17 Jun 1993 21:37:50 GMT
Message-ID: <1vqo7e$8ch_at_gaia.ucs.orst.edu>
Date: 17 Jun 1993 21:37:50 GMT
Message-ID: <1vqo7e$8ch_at_gaia.ucs.orst.edu>
Greetings,
I have a problem that I thought maybe someone in the grp has dealt with
before. I am attempting to retrieve date fields from a table using Pro*C
(Oracle version 6). The code looks like the following:
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20];
VARCHAR password[20];
VARCHAR date_time[20];
EXEC SQL END DECLARE SECTION;
main()
{
/* Log on to ORACLE here */
:
:
EXEC SQL SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI')
INTO :date_time
FROM dual;
fprintf(stdout,"Date_time = %s\n",date_time);
:
/* do some other manipulation */
:
EXEC SQL COMMIT WORK RELEASE;
}