NULL or empty string argument in procedure

I am having a problem with the following procedure. When I try to execute the procedure, and pass either a NULL or an empty string ('') in any of the VARCHAR2 fields, I get the following error:

ERROR at line 1:

ORA-01403: no data found
ORA-06512: at "CEHDAT.PROC_ADD_LANDLORD", line 6
ORA-06512: at line 1

I want to be able to use the procedure to enter records, but I need to be able to pass either NULLs or empty string values for fields that are optional.

Any help would be greatly appreciated!

CREATE OR REPLACE PROCEDURE
CEHDAT.PROC_ADD_LANDLORD(LAST VARCHAR2, FIRST VARCHAR2, MIDDLE VARCHAR2, EMAILADD VARCHAR2, GENDER VARCHAR2, SUFFIX VARCHAR2,
LANDLORD_REMARKS VARCHAR2, JP_COMPANY INTEGER) IS PERSON_KEY NUMBER;
BEGIN
                 INSERT INTO PERSON (LAST_NAME,
FIRST_NAME, MIDDLE_INITIAL, EMAIL, SEX, PERSON_SUFFIX_CD) VALUES
                                    (LAST, FIRST,
MIDDLE, EMAILADD, GENDER, SUFFIX);
              SELECT PERSON_ID INTO PERSON_KEY FROM PERSON
                        WHERE (LAST_NAME = LAST)
AND (FIRST_NAME = FIRST) AND (MIDDLE_INITIAL = MIDDLE) AND
                           (EMAIL = EMAILADD) AND
(SEX = GENDER) AND (PERSON_SUFFIX_CD = SUFFIX);
                         INSERT INTO LANDLORD
(LANDLORD, REMARKS, JP_CO_ID) VALUES

                                    (PERSON_KEY,
LANDLORD_REMARKS, JP_COMPANY);
END; Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 23 2000 - 05:35:41 CST