> Do you have any delete triggers on that table? If so, does that
> reference any UDFs, or run any SQL that causes triggers to fire which
> in turn reference any UDFs? The stored procedure looks OK otherwise.
> Otherwise, try running gfix to see if you have any corrupt records?
>
> Adam
>
>

I validated the db, with no errors. I even did a backup and restore.
There are no UDFs.

The db consists of 2 tables in the database and
the store procedure.

Table 1
/* Table: USER_TYPES */

CREATE TABLE USER_TYPES (
UTYPE VARCHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);



/* Indices definition */

CREATE UNIQUE INDEX PK_USER_TYPES ON USER_TYPES (UTYPE);


Table 2


CREATE TABLE USERS (
USERID VARCHAR (30) NOT NULL,
EMPLOYMENTID VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
CITIZENSHIP VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
SALESPERSON SMALLINT DEFAULT 0,
HIREDATE DATE DEFAULT 'NOW',
TERMINATIONDATE DATE,
FIRSTLINE VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
SECONDLINE VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
CITY VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
STATE VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
CODE VARCHAR (10) CHARACTER SET NONE COLLATE NONE,
TELEPHONE VARCHAR (14) CHARACTER SET NONE COLLATE NONE,
MOBILE VARCHAR (14) CHARACTER SET NONE COLLATE NONE,
EMAIL VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
LOGINID VARCHAR (20) CHARACTER SET NONE COLLATE NONE,
PWD VARCHAR (20) CHARACTER SET NONE COLLATE NONE,
DISCOUNTPERCENT FLOAT DEFAULT 0,
AUTHORIZATIONID VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
UTYPE VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
UINACTIVE SMALLINT DEFAULT 0,
ALIAS VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
STATUS VARCHAR (30) CHARACTER SET NONE COLLATE NONE);



/* Indices definition */

CREATE INDEX FK_USERS ON USERS (UTYPE);
CREATE UNIQUE INDEX PK_USERS_LOGINID ON USERS (LOGINID);
CREATE UNIQUE INDEX PK_USERS_USERID ON USERS (USERID);
CREATE UNIQUE INDEX UK_USERS_PWD ON USERS (PWD);