Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Pro*C Host arrays
Hello,
In Oracle Pro*C/C++ docs, chapter 4, I have :
struct
{
char emp_name[3][10];
int emp_number[3];
int dept_number[3];
} emp_rec;
..
strcpy(emp_rec.emp_name[0], "ANQUETIL"); strcpy(emp_rec.emp_name[1], "MERCKX"); strcpy(emp_rec.emp_name[2], "HINAULT"); emp_rec.emp_number[0] = 1964; emp_rec.dept_number[0] = 5;emp_rec.emp_number[1] = 1974; emp_rec.dept_number[1] = 5; emp_rec.emp_number[2] = 1985; emp_rec.dept_number[2] = 5;
EXEC SQL INSERT INTO emp (ename, empno, deptno)
VALUES (:emp_rec);
But how to insert a date field ?
(how to do "TO_DATE(...)" like in a classic "INSERT INTO ... VALUES" ?)
Thanks in advance.
-- Ce message a ete poste via la plateforme Web club-Internet.fr This message has been posted by the Web platform club-Internet.fr http://forums.club-internet.fr/Received on Fri Mar 21 2003 - 09:38:55 CST