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;