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

Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL and nulls

PL/SQL and nulls

From: Benetnasch <nospam.benetnasch_at_blimey.co.uk>
Date: Wed, 27 Jun 2001 15:33:07 +0100
Message-ID: <F8m_6.22446$cw.1272909@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:33:07 CDT

Original text of this message

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