Re: Full PL/SQL Programs
From: Vincen5158 <vincen5158_at_aol.com>
Date: 24 Mar 1995 16:04:31 -0500
Message-ID: <3kvc4v$se3_at_newsbf02.news.aol.com>
Date: 24 Mar 1995 16:04:31 -0500
Message-ID: <3kvc4v$se3_at_newsbf02.news.aol.com>
>> procedure xyz is
>> n number ;
>> begin
>> n := 1 ;
>> end ;
>> begin
>> xyz ;
>> end ;
You should declare procedure xyz in the declare section of the anonymous
block.
Try this: (I didnt't test this)
DECLARE
procedure xyz is
n number ;
begin
n := 1 ;
end ;
BEGIN
xyz ;
END ;
Hope this works for you.
Received on Fri Mar 24 1995 - 22:04:31 CET