I'm new to PL/SQL.i need a procedure that insert value . i created QABZ table
table QABZ
i wrote a procedure that insert value into my table but does'nt work.
CREATE OR REPLACE PROCEDURE insertQABZ(
P_QNUM IN QABZ.QBZ_NUM%TYPE,
p_QS IN QABZ.QBZ_SERIAL%TYPE,
p_QD IN QABZ.QBZ_DATE%TYPE,
p_QC IN QABZ.VCODE%TYPE
p_PNUM IN QABZ.POLICE_NUM%TYPE,
p_CR IN QABZ.CERTI_NUM%TYPE,
p_PLK IN QABZ.PELAK%TYPE,
p_p IN QABZ.QBZ.PLACE%TYPE)
)
IS
BEGIN
INSERT INTO QABZ ("QBZ_NUM", "QBZ_SERIAL", "QBZ_DATE", "VCODE",,"POLICE_NUM","CERTI_NUM","PELAK","PLACE")
VALUES (p_QNUM ,p_QS ,p_QD ,p_QC,p_PNUM ,p_CR ,p_PLK,p_p);
COMMIT;
END;
question from:
https://stackoverflow.com/questions/65874276/insert-value-procedure-in-pl-sql 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…