Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with pl/sql
On 16 Mar, 16:13, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> The important part here is "most recently executed".
> In the case of the OP the PL/SQL block was never executed
> when it typed RUN, it was currently writing it.
>
> Regards
> Michel
Code copied and pasted directly from the OP's post into my SQL*Plus session:
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 16 16:22:44 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.4.0 - Production
With the OLAP and Data Mining options
SQL> declare
2 a number := 2;
3 begin
4 a := a + 1;
5 end;
6 .
SQL> run;
1 declare
2 a number := 2;
3 begin
4 a := a + 1;
5* end;
PL/SQL procedure successfully completed. Received on Fri Mar 16 2007 - 11:27:14 CDT