Page 1 of 1

Long statements truncated by F8

Posted: Sun 03 Jun 2012 10:58
by 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.

Re: Long statements truncated by F8

Posted: Wed 06 Jun 2012 10:39
by 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.

Re: Long statements truncated by F8

Posted: Sat 09 Jun 2012 15:13
by 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 -------------

Re: Long statements truncated by F8

Posted: Mon 11 Jun 2012 15:44
by 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.