Issue: Generate Execution Plan - (statement followed by comments)

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wi937c-amr
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Issue: Generate Execution Plan - (statement followed by comments)

Post by wi937c-amr » Thu 05 Jul 2012 19:15

Issue:

dbForge Studio for Oracle (v3.1.206) fails to generate an execution plan if the statement is followed by a comment.

Steps to Reproduce:

1 - Connect to database
2 - Open an new SQL tab/document (CTRL-N)
3 - Enter a SQL statement followed by a comment, for example:

Code: Select all

SELECT 1 FROM DUAL;
/* MY COMMENT */
4 - Generate Execution Plan using the toolbar icon or by the menu bar (SQL/Generate Execution Plan)

Expected Result:
Comment following the statement is ignored

Actual Result:
ORA-00911: Invalid Character is displayed and generation of execution plan fails.


WI937C-AMR (CROraDev-XXX6)
Last edited by wi937c-amr on Wed 11 Jul 2012 19:46, edited 2 times in total.

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Issue: Generate Execution Plan

Post by alexa » Fri 06 Jul 2012 12:52

We are currently investigating this issue.

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Issue: Generate Execution Plan - (statement followed by comments)

Post by alexa » Tue 20 Nov 2012 11:45

We would like to let you know that the new build 3.1.243 of dbForge Studio for Oracle where the issue you reported is fixed, has been released and is available for downloading: http://www.devart.com/dbforge/oracle/st ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.

wi937c-amr
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Re: Issue: Generate Execution Plan - (statement followed by comments)

Post by wi937c-amr » Wed 19 Dec 2012 17:23

Thank you for addressing the issue.

Post Reply