Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in Trigger ( PL/SQL: ORA-01744: inappropriate INTO)

SmileApr 27 2009 — edited Apr 27 2009
Hi ,
I've written the trigger in the following format.. As the original trigger is around 700 lines, so just format is written here.. please co-operate..
 CREATE OR REPLACE TRIGGER --
AFTER UPDATE OF COL1
ON TAB1
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN (NOT(OLD.COL1 IS NULL AND NEW.COL1=0))
DECLARE
 --
 --
rowToins PAK1.fdList;
i number;
BEGIN
 IF :NEW.COL2='V' THEN
 INSERT INTO DEST(
  ---
  ---
  D_AT)
 SELECT * FROM ( SELECT --
   ----
   ----
   PAK2.FUN1('AD',TAB10.ID) AS D_AT
 FROM ---
 WHERE --- )
   WHERE D_AT IS NOT NULL;
ELSEIF :NEW.COL2 ='H' THEN
 SELECT * FROM ( SELECT --
   ----
   ----
   PAK2.FUN1('AD',TAB9.ID) AS D_AT
 BULK COLLECT INTO rowToins
 FROM ---
 WHERE --- )
   WHERE D_AT IS NOT NULL;

 i:=rowToins.FIRST;
 WHILE i IS NOT NULL LOOP
 --insert row 1
  PAK1.fun2(rowToins(i).<col>,
  ----
  );
 i:=rowToins.NEXT(i);
 END LOOP;
END IF;
END;
/
The above code is giving the error..
PL/SQL: ORA-01744: inappropriate INTO
So how can i correct the code...

thanks
This post has been answered by Karthick2003 on Apr 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2009
Added on Apr 27 2009
9 comments
774 views