Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with pl/sql

Re: problem with pl/sql

From: gazzag <gareth_at_jamms.org>
Date: 16 Mar 2007 09:27:14 -0700
Message-ID: <1174062434.696314.11480@d57g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US