1/* 2The PL/SQL parser (v1.6) does not parse a standalone 3procedure or function (i.e., not part of a package) when 4the SQL is in the form 5*/ 6CREATE OR REPLACE PROCEDURE foo 7AS /* or IS*/ 8 BEGIN 9 DECLARE 10 l_foo NUMBER; 11 BEGIN 12 l_foo := 1; 13 END; 14 END; 15/* 16When this is processed the only tag reported is 17Procedure foo. If you remove the line with AS, the 18variable l_foo is seen, but then the procedure will not 19compile in Oracle. 20 21Functions seem to have similar problems in that the 22parser will not see inside the function, but removing the 23IS or AS does not remedy the problem for a function. 24*/ 25