Re: PL/SQL: Now it won't let me insert...
From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: 1997/12/08
Message-ID: <01bd046e$15bd67d0$0100007f_at_m7bnv>#1/1
Date: 1997/12/08
Message-ID: <01bd046e$15bd67d0$0100007f_at_m7bnv>#1/1
There are two things which would cause errors in your code: 1. Cuttoff_date and publication_date are DATE columns and yet you are attempting to insert a character literal 'x' in cutoff_date. 2. The date '10-NOV-89' will cause problems unless you know that your database date format is set to 'DD-MON-YY'. It is good practice to always convert a date to a particular format before storage i.e. use TO_DATE('10-NOV-89', 'DD-MON-YY') Tom kyte answered your other query elsewhere.
Regards
Lawrence Simela
Received on Mon Dec 08 1997 - 00:00:00 CET