Re: PL/SQL: Now it won't let me insert...

kgrigg_at_acxiom.com wrote:

> <snip>
>
> create table temp_out
> <snip>
> cutoff_date date,
> directory_number varchar2 (6),
> publication_date date,
> room_code varchar2 (1),
> room_number varchar2 (8))
> tablespace temporary_data;
>
> <snip>

> I have all but one columns defined as varchar2 with one
> column as date. Can any one figure out what is going on here?

I hate to mention this Kelly, but you have got 2 date fields :- cutoff_date and publication_date.
Your insert statement would work if cutoff_date was a varchar2 or if you were inserting a date into it like publication_date.

Cheers,

Ian Received on Thu Dec 11 1997 - 00:00:00 CET