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 -> Re: Pro*C Host arrays

Re: Pro*C Host arrays

From: Brian Beld <BB_at_nospam.com>
Date: Fri, 21 Mar 2003 21:03:42 +0100
Message-ID: <3E7B701E.70700@nospam.com>


Jean a écrit:
> ex :
>
> varchar theDate[3][20];
>
> strcpy (theDate[0].arr, "21/03/03");
> theDate[0].len = strlen (theDate[0].arr);
> ...
> nbRows = 1;
>
> exec sql for :nbRows insert into TABLE (COL_DATE) values (to_date (:theDate,
> 'DD/MM/RR'));

Thanks for the answer but it isn't exactly what I want to do : I want to add a date member in the emp_rec structure which is used directly in the Insert statement . Then I don't know how to convert it with TO_DATE(). Received on Fri Mar 21 2003 - 14:03:42 CST

Original text of this message

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