File: bug722501.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 (24 lines) | stat: -rw-r--r-- 607 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
 
/*
The PL/SQL parser (v1.6) does not parse a standalone
procedure or function (i.e., not part of a package) when
the SQL is in the form
*/
CREATE OR REPLACE PROCEDURE foo
AS /* or IS*/
    BEGIN
	DECLARE
	    l_foo NUMBER;
	BEGIN
	    l_foo := 1;
	END;
    END; 
/*
When this is processed the only tag reported is
Procedure foo. If you remove the line with AS, the
variable l_foo is seen, but then the procedure will not
compile in Oracle.

Functions seem to have similar problems in that the
parser will not see inside the function, but removing the
IS or AS does not remedy the problem for a function.
*/