Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL and nulls
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