Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
884 views
Welcome To Ask or Share your Answers For Others

1 Answer

Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...