Re: PL/SQL and nulls

From: Travis <otaupin_at_ifrance.com>
Date: Wed, 27 Jun 2001 16:41:18 +0200
Message-ID: <9hcr3u$t16$1@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:41:18 CDT