Long statements truncated by F8

[azabluda]

Version 3.1.198, Trial. Direct mode. Unicode.

"Execute Current Statement (F8)" command appears to truncate the statement somewhere at ~64k giving "PLS-00103" error, whilst "Execute (F5)" seems to work fine.

[alexa]

Could you please send the SQL script that you are executing straight to our support system at supportATdevartDOTcom? So we will keep further correspondence with you via this system.

[azabluda]

The problem seems to have nothing to do with the size of the statement. Sorry for the misleading title of the topic.

F8 fails to execute the 1st statement of the following script

Code: Select all

CREATE OR REPLACE PACKAGE test1
IS
   FUNCTION test return varchar2;
END;
/

CREATE OR REPLACE PACKAGE BODY test1
IS
  FUNCTION test RETURN VARCHAR2
  IS
  BEGIN
    RETURN NULL;
  END;
END;
/

Code: Select all

3 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   ; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue. SQL.sql 4 3 

F5 copes with both

Code: Select all

------ Execution started: SQL.sql ------

Execute succeeded [0,040s]
Execute succeeded [0,036s]

------------ Done: SQL.sql -------------

[alexa]

We were able to reproduce the problem and will fix it in one of the next builds of the product. We will notify you once this build is available for downloading.