sequence problem

[Johnson, Harold A EDUC:EX]

Hi all.   When trying to add a record to an Oracle table from VMS using
Powerhouse, the auto generation using sequence values for a primary key
doesn't work; however, it works when using SQLPLUS from VMS.  Any ideas?

The trigger on the Oracle table is:

...
BEGIN
    IF (operation = 'INS') THEN
        BEGIN
			IF (cg$ind.ADRTYP_ID = FALSE OR cg$rec.ADRTYP_ID is
NULL) THEN
				SELECT ITS_SURROGATE_KEY_SEQ.nextval
				INTO   cg$rec.ADRTYP_ID
				FROM   DUAL;
				cg$ind.ADRTYP_ID := TRUE;
			END IF;
        EXCEPTION WHEN OTHERS THEN
...