Come Trovare Collaboratori Domestici per la Deodorizzazione

Scopri come affrontare gli errori nei trigger di Oracle con il nostro articolo informativo. Analizziamo le problematiche comuni, come l'errore PL/SQL: ORA-00928, e offriamo soluzioni pratiche per migliorare la tua programmazione. Unisciti alla discussione per condividere esperienze e suggerimenti utili.

Forum Oracle Forums Oracle Development Error in Trigger Results 1 to 6 of 6 Thread: Error in Trigger Tweet #1 Join Date Jun 2001 Posts 171 Hi I have a Trigger Which I wrote like this CREATE OR REPLACE TRIGGER T_E_CALLS AFTER INSERT OR UPDATE ON E_CALLS FOR EACH ROW DECLARE V_CALL_ID E_CALLS.CALL_ID%TYPE; V_USER_ID E_CALLS.USER_ID%TYPE; V_LOCATION E_CALLS.LOCATION_ID%TYPE; V_SUBJECT E_CALLS.SUBJECT%TYPE; V_PRIORITY E_CALLS.PRIORITY%TYPE; V_CALL_TIMESTAMP E_CALLS.CALL_TIMESTAMP%TYPE; V_CALL_DATE E_CALLS.CALL_DATE%TYPE; BEGIN :NEW.CALL_ID := E_CALLS_SEQ.NEXTVAL; SELECT CALL_ID, USER_ID, LOCATION_ID, SUBJECT, PRIORITY, CALL_TIMESTAMP, CALL_DATE INTO V_CALL_ID, V_USER_ID, V_LOCATION, V_SUBJECT, V_PRIORITY, V_CALL_TIMESTAMP, V_CALL_DATE FROM E_CALLS WHERE CALL_ID = :NEW.CALL_ID; :NEW.CALL_DATE := SYSDATE; END; / When I try to compile it, I get the following error PL/SQL: ORA-00928: missing SELECT keyword None of the columns in the E_CALLS table are nullable. Can anybody help me out. Thanks, Amit #2 Join Date May 2000 Location ATLANTA, GA, USA Posts 3,135 The trigger should be CREATE OR REPLACE TRIGGER T_E_CALLS AFTER INSERT OR UPDATE ON E_CALLS FOR EACH ROW BEGIN :NEW.CALL_ID := E_CALLS_SEQ.NEXTVAL; :NEW.CALL_DATE := SYSDATE; END; / Tamil #3 Join Date Jun 2001 Posts 171 Thanks Tamil. I tried your trigger, but I get the same error. I tried the same trigger without the variables, like this CREATE OR REPLACE TRIGGER T_E_CALLS AFTER INSERT OR UPDATE ON E_CALLS FOR EACH ROW BEGIN :NEW.CALL_ID := E_CALLS_SEQ.NEXTVAL; :NEW.CALL_DATE := SYSDATE; END; / But I get the same error. Thanks, Amit #4 Join Date May 2000 Location ATLANTA, GA, USA Posts 3,135 Have you created the trigger with rollback segment? Tamil #5 Join Date Jun 2001 Posts 171 No. I have not created a rollback segment. Amit #6 Join Date May 2000 Location ATLANTA, GA, USA Posts 3,135 You don't need a rollback segment. Tamil Posting Permissions You may not post new threads post new threads You may not post replies post replies You may not post attachments post attachments You may not edit your posts edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is On Forum Rules Click Here to Expand Forum to Full Width