File: 3184782.sql

package info (click to toggle)
geany 2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 39,300 kB
  • sloc: ansic: 168,600; cpp: 77,562; sh: 5,344; makefile: 1,694; cs: 1,233; javascript: 1,024; python: 580; f90: 537; vhdl: 504; sql: 503; lisp: 436; fortran: 389; php: 278; ada: 201; ruby: 163; java: 131; asm: 131; perl: 119; cobol: 88; tcl: 77; erlang: 73; xml: 66; ml: 27; sed: 16; pascal: 15; haskell: 6
file content (41 lines) | stat: -rw-r--r-- 738 bytes parent folder | download | duplicates (17) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
create or replace package body p_test is

procedure do_this_stuff is begin
if true then
    for idx in z+1 .. myarr.last loop
        if myarr.exists(idx) then
            null;
        end if;
    end loop;

elsif true then
    for idx in myarr.first .. myarr.last loop
        if myarr.exists(idx) then
            null;
        end if;
    end loop;
end if;
end do_this_stuff;

procedure process_this (
    p_flag in boolean
) is
begin
    null;
end process_this;

procedure myfn1 (
    p_str1 in varchar2,
    p_str2 in varchar2
) is begin
process_this(false);
end myfn1;

procedure myfn2 (
    p_str1 in varchar2,
    p_str2 in varchar2
) is begin
process_this(true);
end myfn2;

end p_test;