Advertisement
Guest User

Untitled

a guest
Jan 17th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. Packages:
  2. CREATE OR REPLACE PACKAGE BODY pkg
  3. AS
  4. PROCEDURE volunteers_insert(v_id IN number, v_name IN varchar2,v_type IN varchar2, v_address IN varchar2,v_gender IN varchar2, v_contact IN NUMBER, firstname IN varchar2, lastname in varchar2, phone in number)
  5. IS
  6. BEGIN
  7. INSERT INTO VOLUNTEERS(vol_id,vol_name,vol_type,vol_address,vol_gender,vol_contact,gp_firstname,gp_lastname,gp_phone ) VALUES
  8. (VOLUNTEERS_seq.nextval, v_name ,v_type , v_address ,v_gender , v_contact, firstname , lastname, phone );
  9. COMMIT;
  10. END volunteers_insert;
  11.  
  12. FUNCTION volunteer_count RETURN number
  13. IS
  14. abc number;
  15. BEGIN
  16. SELECT COUNT(vol_id) INTO abc FROM vol_project GROUP BY p_id;
  17. RETURN abc;
  18. END volunteer_count;
  19. END;
  20.  
  21.  
  22.  
  23. CODE:
  24. DROP PACKAGE package;
  25. CREATE OR REPLACE PACKAGE package
  26. AS
  27. PROCEDURE v_insert(vol_id IN number, vol_name IN varchar2,v_type IN varchar2, vol_address IN varchar2,vol_gender IN varchar2, vol_contact IN NUMBER, firstname IN varchar2, lastname in varchar2, phone in number);
  28. FUNCTION v_count RETURN number;
  29. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement