Long statements truncated by F8

Long statements truncated by F8

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

Re: Long statements truncated by F8

Postby 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.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17

Re: Long statements truncated by F8

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

Re: Long statements truncated by F8

Postby 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.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle