Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE PR_GENEROWANIE_SPRZEDAZY (v_min DATE,v_max DATE ,v_ilosc NUMBER) AS
- v_data DATE;
- BEGIN
- FOR i IN 1..v_ilosc LOOP
- SELECT fn_losuj_date(v_min,v_max) INTO v_data FROM dual;
- pr_generowanie_faktury(v_data);
- END LOOP;
- COMMIT;
- END PR_GENEROWANIE_SPRZEDAZY;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement