Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Pro*C Host arrays

Pro*C Host arrays

From: Brian Beld <BB_at_nospam.com>
Date: 21 Mar 2003 15:38:55 GMT
Message-ID: <2003321-163855-31456@foorum.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US