Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error: 'ORA-01400: cannot insert NULL into ('

Re: Error: 'ORA-01400: cannot insert NULL into ('

From: Randy Harris <randy_at_SpamFree.com>
Date: Sun, 22 Jan 2006 18:29:12 GMT
Message-ID: <Y9QAf.12967$_S7.6238@newssvr14.news.prodigy.com>

"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in message news:DdWdnf4T3tt9XE7eRVn-gg_at_comcast.com...
>
> "Randy Harris" <randy_at_SpamFree.com> wrote in message
> news:jhAAf.12822$_S7.9782_at_newssvr14.news.prodigy.com...
> >
> > <fitzjarrell_at_cox.net> wrote in message
> > news:1137883868.329766.50110_at_f14g2000cwb.googlegroups.com...
> > >
> > >
> > > The response by Mladen is, therefore,
> > > correct, as is my response providing the same advice.
> > >
> > >
> > > David Fitzjarrell
> > >
> >
> > Except, the OP specifically stated that he didn't want to use a
sequence.
> >
> >
> >
> Well, I would like to lose weight without exercise or eating less too.
> Jim
>

I wasn't suggesting that it made sense to do it without a sequence. However, if there were a valid reason for not using one (ya, I know, that seems inconceivable) it could be done with a function. Something that emulated the behavior of a sequence.

Randy Harris
BTW - If you make any progress on that weight loss plan, please pass along the secret. Received on Sun Jan 22 2006 - 12:29:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US