Identity Column and stored procedure in Oracle Help
From: Lakshmi <lakshmiysr_at_yahoo.com>
Date: 21 Oct 2002 11:18:54 -0700
Message-ID: <d7821b44.0210211018.8700_at_posting.google.com>
Date: 21 Oct 2002 11:18:54 -0700
Message-ID: <d7821b44.0210211018.8700_at_posting.google.com>
I am new to Oracle…Please can anyone help
I have migrated my data from Microsoft SQL to Oracle. On migration the tool created a trigger for the identity column. Now I get an error ‘not enough values' in my stored procedure INSERT INTO sa.Alertlog VALUES (SP_ALERT_SP.alertNum);
Table: Alertlog
Fields: alertlognum(identity column), alertNum
Trigger: TR_S_2536_Alertlog
BEGIN
SELECT sa.S_2536_ALERTLOG.nextval
INTO omwb_emulation.globalPkg.identity
FROM dual;
:new.ALERTLOGNUM:=omwb_emulation.globalPkg.identity;
END;
Received on Mon Oct 21 2002 - 20:18:54 CEST