Problem: auto select in SQL window

[ScottMattes]

PLSD v8

I have a select, followed by a begin/package call/end, followed by another select. All three of these end with a semi-colon as they should.

select 1 from dual;

begin
  dbms_output.put_line('asdf');
end;

select 2 from dual;

I did ctl-a to select all three statements and then pressed F8 to execute - the hope was one result tab for the before picture, one tab with nothing from the begin/end, and another tab for the after picture (at the moment I cannot do flashback queries).

The first select executes creating a tab, the second tries to execute, but I get the error "ora-06550: line 7, column 1: pls-00103; encountered the symbol "select" and the begin/end and last select are hilighted. There are then 2 result tabs.

If I manually select the begin/end statement it executes correctly (although after execution the begin/end and select are hilighted). And the only way to get the last select to execute is if I manually select it, otherwise autoselect tries to execute the begin/end and select.

 

[patch]

I think you should put in a / as the first character on the line following end;

select 1 from dual;

begin
  dbms_output.put_line('asdf');
end;
/

select 2 from dual;

The semicolon in PL/SQL signals the end of the statement. The slash will execute the statement.

Hope this helps.

 

[ScottMattes]

Thank you Patrick, that was what I was missing.