Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
850 views
in Technique[技术] by (71.8m points)

plsql - insert value procedure in PL/SQL

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

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

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...