| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pro*C Host arrays
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
![]() |
![]() |