Long statements truncated by F8

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
azabluda
Posts: 34
Joined: Thu 10 Sep 2009 14:45

Long statements truncated by F8

Post by azabluda » Sun 03 Jun 2012 10:58

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
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Long statements truncated by F8

Post by alexa » Wed 06 Jun 2012 10:39

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
Posts: 34
Joined: Thu 10 Sep 2009 14:45

Re: Long statements truncated by F8

Post by azabluda » Sat 09 Jun 2012 15:13

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
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Long statements truncated by F8

Post by alexa » Mon 11 Jun 2012 15:44

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.

Post Reply