Great
A reader, August 01, 2003 - 8:48 am UTC
Great Answer
Very clear
jignesh, August 01, 2003 - 11:09 am UTC
Great answer with example asusual.
Thanks a LOT.
Great Sharing
Javed A. Khan, September 13, 2011 - 4:28 am UTC
Wonderfull explaination. Thanks Tom.
Wonderful Explanation
rakesh, May 03, 2012 - 3:47 am UTC
Explained and showed in wonderful way.
A reader, July 19, 2012 - 9:16 am UTC
yes great example, i was also facing same problem but not it is working. Thanks
Good explanation
Catherine, October 04, 2012 - 12:22 am UTC
Thank u so much. i tried it and it's working fine. the explanation was clear cut.
required forward declaration
Naeel Maqsudov, January 09, 2013 - 7:39 am UTC
declare
procedure qwe1;
-- REQUIRED forward declaration
-- in case of mutual recursion
procedure qwe2
as
begin
...
qwe1;
end;
procedure qwe1
as
begin
...
qwe2;
end;
begin
null;
end;
/
Here we cannot avoid of using a forward declaration.
Of course this is a very rare case.
Rather, just methodical.
January 14, 2013 - 12:50 pm UTC
some would say "a very bad case"
to have A call B and B call A would fit my description of "something you should probably not be doing"
One more situation when the forward reclaration is mandatory
Naeel Maqsudov, January 13, 2013 - 1:50 pm UTC
Declaration section must contain local function declarations after variables declaration. If you want to initialize a variable by a function, you have to use forward declaration of the function:
declare
function TVar1 return anytype;
x anydata;
Var1 anytype:=TVar1;
...
function TVar1 return anytype as
AType anytype;
begin
.....
RETURN AType;
end;
...
BEGIN
...
END;
/
pl/sql
Natarajan, September 22, 2015 - 8:51 am UTC
Vow! Very Nice and clear explanation,a lot of Thanks
Vikrant, April 14, 2016 - 7:23 am UTC
nice explanation thanks thomas.
Great Explanation!!!
Esakki Raja Esakki Muthu, May 04, 2017 - 1:16 pm UTC