question: A stored procedure to insert records into deliveries table

HINT create stored procedure with parameters for each field in the deliveries table for ex customer address, phone, email and receivers’s address etc

 

 

this is my answer, this store procedure right or wrong. if wrong, can you share with me

 

create or replace PROCEDURE ADD_ORIENT

(

EXCUSTOMER_NAME IN VARCHAR2

, EXCUSTOMER_PHONE IN VARCHAR2

, EXCUSTOMER_EMAIL IN VARCHAR2

, EXCUSTOMERRECEIVERADDRESS IN VARCHAR2

) AS

BEGIN

NULL;

END ADD_ORIENT;

FacebookTwitterLinkedin
Pin It
Joomla Tutorials for Beginners