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

"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