Re: Foriegn key checking.

From: Mario van Essen <marvaes_at_hacom.nl>
Date: 1997/10/15
Message-ID: <34492436.3616228@news.hacom.nl>#1/1

On 13 Oct 1997 05:51:39 GMT, "Mark Parssey" <markpa_at_delm.tas.gov.au> wrote:

>I have a table which is driving me around the twist.
>
>It is being used as a foreign key and is stopping the app. by failing to
>query successfully.
>
>The table holds only a few values, the key field is char 3 & currently has
>the values 3.1, 3.2, 4 & 5.
>

Mark,

Here I stopped reading because the problem lies there. Due to the fact that you are using -spacing- or no fully filled columms in a char 3 Oracle has some handling problems there. If you change the char 3 into varchar 3 everything will work fine again...

Mario Received on Wed Oct 15 1997 - 00:00:00 CDT