Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Now it won't let me insert...
shouldn't your insert contain the to_date() function??? I guess it would be something like:
insert into temp_out values ('x','x','x',
'x','x','x','x', 'x','x','x', 'x','x', 'x','x','x','x', 'x','x','x', 'x','x','x', 'x','x','x', 'x','x','x','x', 'x',to_date('01-NOV-89','dd-mmm-yy'), 'x','x');
Cheers!
kgrigg_at_acxiom.com wrote:
> <snip>
> > 165> /* Do Insert of last record if primary */
> > 166> insert into temp_out values ('x','x','x',
> > 167> 'x','x','x','x',
> > 168> 'x','x','x',
> > 169> 'x','x',
> > 170> 'x','x','x','x',
> > 171> 'x','x','x',
> > 172> 'x','x','x',
> > 173> 'x','x','x',
> > 174> 'x','x','x','x',
> > 175> 'x','01-NOV-89',
> > 176> 'x','x');
> > 177> end if;
> > 178>
> > 179>
> > 180> end loop;
> > 181>
> > 182> commit;
> > 183>
> > 184>
> > 185>
> > 186> end;
> > 187>
> > 188>
> > ORA-01722: invalid number
> > ORA-06512: at line 166
> >
> ><snip>
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Sun Dec 14 1997 - 00:00:00 CST