Advertisement
Guest User

Untitled

a guest
Aug 28th, 2019
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROCEDURE GET_DRIVERPLANID
  2. (
  3.   p_Id OUT DRIVERPLAN.PLANNUMBER%TYPE
  4. )
  5. AS
  6. BEGIN
  7.   SELECT SEQ_DRIVERPLAN.NEXTVAL INTO p_Id FROM dual;
  8. END;
  9.  
  10.  
  11. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement