Re: PL/SQL and nulls

Thanks for the suggestion - I'll have a look.

Travis <otaupin_at_ifrance.com> wrote in message news:9hcr3u$t16$1_at_reader1.imaginet.fr...
> Perhaps have you a ',' instead of '.' in one of your numerics fields !?
>
> Olivier.
>
>
> Benetnasch <nospam.benetnasch_at_blimey.co.uk> a écrit dans le message :
> F8m_6.22446$cw.1272909_at_monolith.news.easynet.net...
> > I have a PL/SQL procedure which is inserting records into a database.
> >
> > The values to put into this database are taken from various variables
> > that I have created.
> >
> > I'm getting the following error message when I try to insert into
> > the database:
> >
> > "ORA-06502: PL/SQL: numeric or value error"
> >
> > ... because (I think) some of the variables are NULL. The corresponding
> > columns in the table aren't "NOT NULL", though.
> >
> > What am I doing wrong?
> >
> > Any help'd be appreciated - thanks.
> >
> > --
> > Benetnasch
> > Remove "nospam."
> >
> >
>
>
Received on Wed Jun 27 2001 - 09:59:48 CDT