Skip to content

Instantly share code, notes, and snippets.

@velll
Created May 5, 2014 11:20
Show Gist options
  • Select an option

  • Save velll/c3df49ea11bf70d3ab0c to your computer and use it in GitHub Desktop.

Select an option

Save velll/c3df49ea11bf70d3ab0c to your computer and use it in GitHub Desktop.
Nested tables empty elements
DECLARE
tbl_Args NUMBER_TABLE := NUMBER_TABLE();
BEGIN
RAISE_APPLICATION_ERROR(-20100, tbl_ARGS.COUNT); -- 0
END;
/
DECLARE
tbl_Args NUMBER_TABLE := NUMBER_TABLE();
BEGIN
tbl_ARGS.EXTEND(8);
RAISE_APPLICATION_ERROR(-20100, tbl_ARGS.COUNT); -- 8
END;
/
DECLARE
tbl_Args NUMBER_TABLE := NUMBER_TABLE();
vch_Args VARCHAR2(1000);
BEGIN
tbl_ARGS.EXTEND(8);
tbl_ARGS(1) := 1;
tbl_ARGS(3) := 3;
FOR i IN 1..tbl_ARGS.COUNT
LOOP
vch_Args := vch_Args || i || ':' || tbl_Args(i) || '; ';
END LOOP;
RAISE_APPLICATION_ERROR(-20100, vch_Args); -- 1:1; 2:; 3:3; 4:; 5:; 6:; 7:; 8:;
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment