Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create or replace procedure readEmpDetails (empRowList NUMBER_LIST_TYPE,
- created_by VARCHAR2,
- accessid NUMBER )
- is
- begin readEmpDetails([124, 155, 147], '100', 2); end;
- create or replace type T_array_readEmpDetails AS VARRAY(10) of number(4)
- /
- Create or replace procedure readEmpDetails (t_ar T_array_readEmpDetails,
- created_by VARCHAR2,
- accessid NUMBER )
- is
- begin
- FOR i IN 1..t_ar.count LOOP
- dbms_output.put_line(t_ar(i));
- END LOOP;
- end;
- /
- DECLARE
- v T_array_readEmpDetails;
- BEGIN
- v := T_array_readEmpDetails();
- v.EXTEND(3);
- v(1) := 124;
- v(2) := 155;
- v(3) := 147;
- readEmpDetails(v,'A',1);
- END;
- /
Add Comment
Please, Sign In to add comment