Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Packages:
- CREATE OR REPLACE PACKAGE BODY pkg
- AS
- 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)
- IS
- BEGIN
- INSERT INTO VOLUNTEERS(vol_id,vol_name,vol_type,vol_address,vol_gender,vol_contact,gp_firstname,gp_lastname,gp_phone ) VALUES
- (VOLUNTEERS_seq.nextval, v_name ,v_type , v_address ,v_gender , v_contact, firstname , lastname, phone );
- COMMIT;
- END volunteers_insert;
- FUNCTION volunteer_count RETURN number
- IS
- abc number;
- BEGIN
- SELECT COUNT(vol_id) INTO abc FROM vol_project GROUP BY p_id;
- RETURN abc;
- END volunteer_count;
- END;
- CODE:
- DROP PACKAGE package;
- CREATE OR REPLACE PACKAGE package
- AS
- 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);
- FUNCTION v_count RETURN number;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement