Re: Working with constants in SQL*LOAD

From: <kko_at_hk.super.net>
Date: Tue, 01 Sep 1998 09:45:08 GMT
Message-ID: <35ebc1e2.8624967@news.hk.super.net>

On 26 Aug 1998 11:27:17 GMT, "luis gregorio" <lgregorio_at_aliuap1.mailpac.pt> wrote:

You'h better load in using varchar2(8) and use pl/sql to convert it....

>I am trying to use SQL*LOAD to load a file into a table. There are a date
>column (DATA_MOV) in whitch I whant to insert a constant (18000101) but
>Loader said:
>
>Record 1: Rejected - Error on table MOVS, column DATA_MOV.
>ORA-01843: not a valid month
>
>It is possible to format a constant?
>
>What can I do?
>
>Helena Lopes.
>
Received on Tue Sep 01 1998 - 04:45:08 CDT