Skip to content

Instantly share code, notes, and snippets.

@zelark
Created March 17, 2014 12:53
Show Gist options
  • Save zelark/9598671 to your computer and use it in GitHub Desktop.
Save zelark/9598671 to your computer and use it in GitHub Desktop.
create or replace procedure api(p1 out number,
p2 out number,
p3 out number,
p4 out number,
p5 out number,
p6 out number,
p7 out number,
p8 out number,
p9 out number)
as
begin
p1 := 1;
p2 := 2;
p3 := 3;
p4 := 4;
p5 := 5;
p6 := 6;
p7 := 7;
p8 := 8;
p9 := 9;
end api;
declare
l_number_i_am_interested_in number;
l_dummy number;
begin
api(p1 => l_number_i_am_interested_in
p2 => l_dummy,
p3 => l_dummy,
p4 => l_dummy,
p5 => l_dummy,
p6 => l_dummy,
p7 => l_dummy,
p8 => l_dummy,
p9 => l_dummy);
dbms_output.put_line(l_dummy);
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment