Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Dev Tools for Visual Studio 2017, Schema Compare errors

3780245Nov 8 2018 — edited Nov 14 2018

This question has already been asked in January, 2018, but it is now archived and not answered.

I have Oracle 11g databases that I want to compare schema.  In the latest ODT downloaded yesterday, I have imported the schema of database A.  I run "Oracle Schema Compare" in solution explorer.  I "Select Source" as the project for database A.  I "Select Target" as a database connection.  Click OK, and it throws dozens of errors, all of the type, "There is no possible parse follow up at the token..."  It appears to be an especially strict scan of the code.  For example:

Severity Code Description Project File Line Suppression State

Error There is no possible parse follow up at the token "case" :

>>>

from dec_ACCOM_GROUP ag2 where ag2.ada_svc_id=p_ada_svc_id and sec_done ='Y')) then

               'Y'

        else 'N'

        end case into retVal from dual;

            ^                         

return retVal;

END Get_DEC_ADA;

               

>>>

Possible follow up tokens are:

identifier

'AS'

'*'

'+'

'-'

'/'

'|'

'BULK'

'FROM'

'INTO' db db \C:\LSTS Codebase\LSTS Source Code\Development\Oracle Project\xxx\Functions\db.GET_DEC_ADA.sql 26

The code is in production and works just fine, not throwing any errors.  Is this a case where the parser doesn't like our coding style?  What is going on here?

Message was edited by: 3780245, corrected word usage.

Comments

Processing

Post Details

Added on Nov 8 2018
3 comments
268 views