Hi pren...
Saya punya mslh ketika meng-execute trigger dibawah, dengan error:
ORA-06512: at "NCS.START_DATE", line 2
ORA-04088: error during execution of trigger 'NCS.START_DATE'
Tolong pencerahanya donk... :D
thanks
CREATE OR REPLACE TRIGGER START_DATE
BEFORE INSERT OR UPDATE ON TB_R_NQC_ALL
FOR EACH ROW
DECLARE
ERR_UPDATE EXCEPTION;
BEGIN
IF to_char(:NEW.DAILY_QTY_START_DT,'DD') <> '01' THEN
RAISE ERR_UPDATE;
END IF;
EXCEPTION
WHEN ERR_UPDATE THEN
Raise_application_error(-20000,'ERROR COY');
END START_DATE;
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
[Non-text portions of this message have been removed]
