1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
PROCEDURE insert_orga (
nb_jud_cat IN NUMBER(4,0),
nb_orga_type IN NUMBER(4,0)
) IS
siret NUMBER(14,0);
jud_cat_id NUMBER(4,0);
orga_type_id NUMBER(4,0);
BEGIN
SELECT trunc(dbms_random.value(10000000000000,99999999999999)) INTO siret FROM DUAL;
SELECT trunc(dbms_random.value(1,nb_jud_cat)) INTO jud_cat_id FROM DUAL;
SELECT trunc(dbms_random.value(1,nb_orga_type)) INTO orga_type_id FROM DUAL;
INSERT INTO organization (orga_id, orga_type_id, judicial_category_id, siret, name, name_complement)
VALUES (SEQ_ORGANIZATION.NEXTVAL,orga_type_id, jud_cat_id ,siret,'nom','complenom');
COMMIT;
END insert_orga; |
Partager