| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Dan | Date: | January 8 2010 4:04am |
| Subject: | RE: table export in cron | ||
| View as plain text | |||
On Thu, 7 Jan 2010 15:48:24 +0200, "machiel.richards" <machiel.richards@stripped> wrote: > Hi All > > What the Oracle guys found was that some of the fields were blank even > though the fields were configured as not nullable. > > I found that where this is the case, the users entered a blank space > which is then counted as a character and is thus not null. > > This is causing all kinds of havoc for them as Oracle apparently still > sees this as nulls. I'm not sure what export method you're using, but you should be able to fix this by specifying to quote fields. Dan
| Thread | ||
|---|---|---|
| • table export in cron | machiel.richards | 6 Jan |
| • Re: table export in cron | Gary Smith | 6 Jan |
| • Re: table export in cron | Mikhail Berman | 6 Jan |
| • Re: table export in cron | sureshkumarilu | 6 Jan |
| • Re: table export in cron | Michael Dykman | 6 Jan |
| • Re: table export in cron | Nicola Salvemini | 7 Jan |
| • RE: table export in cron | machiel.richards | 7 Jan |
| • Re: table export in cron | Joerg Bruehe | 7 Jan |
| • RE: table export in cron | Dan | 8 Jan |
