Anjali Khan

Anjali Khan

  • NA
  • 867
  • 213.8k

created procedure but getting error ?

Feb 7 2017 5:33 AM

hi frnds

I created procedure using oracle data base.

here I am using 3 tbles where I want to insert the data using 3 tables I created this but getting error
 
I am sharing the code please let me know where I did mistake I checked by internet but not getting solution
CREATE OR REPLACE PROCEDURE PROC_INSERT_RECORD
  (
 P_PROJ_ID  VARCHAR2,              (table1)
 P_ASSIGNEDTO  VARCHAR2,
 P_DUE_DT  VARCHAR2,               (table 2)
 P_PROB_STATEMENT  VARCHAR2   (table 2) 
  )
AS
BEGIN
--add Record.
INSERT INTO App_UsER (PROJ_ID, ASSIGNEDTO, DUE_DT, PROB_STATEMENT)
VALUES(P_PROJ_ID, P_ASSIGNEDTO, P_DUE_DT, P_PROB_STATEMENT);
COMMIT;
END PROC_INSERT_RECORD; 

Answers (1)