9 Replies Latest reply: Mar 21, 2014 4:24 AM by BartVdT RSS

    Error during 'Open Declaration' in sql developer 4.0.0.13.80

    AnkitV

      Hi All

       

      I am receiving following error when i right click on a procedure/view in sql worksheet and click on 'Open Declaration' in sql developer 4.0.0.13.80 ...

       

      SEVERE2745716283434oracle.ide.controller.IdeActionError during handleEvent on action 'Open Declaration' (id=415). None of the attached controllers handled the action. - oracle.ide.controller.IdeAction$ControllerDelegatingController@9fc5dfe2[oracle.ideimpl.controller.MetaClassController@9fc5dfe2[oracle.dbtools.parser.plsql.IdentifierDefinitionLookup]].

      Can somebody tell me if there is some problem at my side or is it a bug in SQL developer ?

       

      Thanks

        • 1. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
          Siva-Oracle

          What you mean by procedure/view in SQL worksheet? Are you trying to right click in Navigator?

          Please attach the screenshot for your issue

          • 2. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
            Jeff Smith Sqldev Pm-Oracle

            I can say that it 'works for me,' so we'll need more information.

             

            Are you trying to open a procedure in your schema, or someone else's?

             

            You could try running SQL Developer in DEBUG mode for more feedback on the error stack.

             

            Close SQL Developer

             

            Open the SQLDeveloper.conf file in your bin directory (of the sql developer install directory).

             

            Edit the last line of the file to say 'IncludeConfFile sqldeveloper-debug.conf' -- basically remove the 'non' bit that's already there.

             

            Restart SQLDev and try again - open the Log panel, and copy out the Messages around your SEVERE one above.

            • 3. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
              AnkitV

              Hi

               

              I am trying to open the declaration for procedure belonging to my schema only...

               

              I tried the way you said --- here is the content of log relevant to the event "Open declaration"

               

              SEVERE    1531    8    oracle.ide.controller.IdeAction    Error during handleEvent on action 'Open Declaration' (id=415).

              None of the attached controllers handled the action.

              - oracle.ide.controller.IdeAction$ControllerDelegatingController@933ddafa[oracle.ideimpl.controller.MetaClassController@933ddafa[oracle.dbtools.parser.plsql.IdentifierDefinitionLookup]].

               

              INFO    1530    1    oracle.dbtools.parser.plsql.IdentifierDefinitionLookup    Source offset:21

              INFO    1529    9493    oracle.dbtools.parser.plsql.IdentifierDefinitionLookup    Context menu declaration offset:21

               

              thanks.

              • 4. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                Vadim Tropashko-Oracle

                Looks like bug. Can you post the source code that you have in worksheet?

                • 5. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                  AnkitV

                  i just have a view , and i am right clicking on it and trying to open 'open declaration'.

                  • 6. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                    rp0428

                    AnkitV wrote:

                     

                    i just have a view , and i am right clicking on it and trying to open 'open declaration'.

                    What does that mean 'i just have a view'?

                     

                    You said you have a 'procedure'

                    I am trying to open the declaration for procedure belonging to my schema only...

                    • 7. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                      AnkitV

                      Be it procedure/view (as i mentioned in initial post too), both have some SQL declaration behind them.

                      Main issue is "open declaration" option is not working as intended.

                      Thanks

                      • 8. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                        ening

                        I can repdouce it in someway, and has log a bug for it

                         

                        Thanks

                        Emily

                        • 9. Re: Error during 'Open Declaration' in sql developer 4.0.0.13.80
                          BartVdT

                          In sqldeveloper v4.0.1.14 - same message

                           

                          Doing an Open Declaration on a simple database table, the following message is shown:

                           

                          Too many objects - Only 2 records will bedisplayed - Please refine your search criteria.

                           

                          I hope that the logging below might be helpful.

                           

                          The logging reports:

                          -------------- begin logging ------------------

                          FINER91535oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning true for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO9140oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning false for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO9130oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning false for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO9120oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning false for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO9111oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning false for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO910115oracle.dbtools.raptor.controls.grid.RaptorGridTable$1update returning false for Grid1oracle.ide.Context[{Context.EVENT=null_key_12349123847123948712390487123904871239478, Context.VIEW=Editor2, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@33d98734, Context.SELECTION=[Loracle.ide.model.Element;@e3b8184, Context.WORKSPACE=Databases.jws, Context.NODE=KV_INCASSO_METHODE, Context.PROJECT=IdeConnections#ING+EP+(TRUNK).jpr}]
                          INFO909378oracle.dbtools.raptor.controls.grid.RaptorGridPersistedSettingsPersisted settings for this table could not be loaded
                          FINER9081oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9072oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9062oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER90513oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9040oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9032oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9021oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9017oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER9000oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER8992oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER89828oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER89739oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER896240oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          INFO8953oracle.dbtools.raptor.dialogs.actions.XMLBasedObjectActionCould not process user actions caused by Start of root element expected. at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:326)
                          FINER8941oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER8930oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER8921oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER8912oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          FINER89045oracle.dbtools.raptor.utils.AbstractFolderedXmlFolder:Unsupported node in xml:#comment
                          INFO8892oracle.dbtools.db.DBUtil$2Prepared:

                          with alter_roles as (

                            select role from role_sys_privs

                            where privilege = :PRIV1

                          ), tc_roles as (

                            select role from  alter_roles

                            union

                            select role

                            from role_role_privs

                            start with granted_role in (select role from alter_roles)

                            connect by granted_role = prior role

                          ) select sum(cnt) privs from (

                          select count(*) cnt from user_tab_privs
                          where owner = :OWNER and table_name = :NAME and privilege = 'ALTER'

                                  union all

                              select count(*) from user_sys_privs

                              where privilege = :PRIV1

                                  union all

                              select count(*) from Dba_tab_privs

                              where GRANTOR = :OWNER and table_name = :NAME

                              and privilege = 'ALTER' and grantee = 'PUBLIC'

                                  union all

                              SELECT count(1) FROM user_role_privs

                              WHERE granted_role IN (select role from tc_roles)

                          )

                          INFO88822oracle.dbtools.db.DBUtil$2Persisted settings for this table could not be loaded
                          INFO8870oracle.dbtools.db.DBUtil$2Persisted settings for this table could not be loaded
                          INFO8862oracle.dbtools.db.DBUtil$2Persisted settings for this table could not be loaded
                          FINER8850oracle.dbtools.db.DBUtil$2

                           

                           

                               Loading....

                          select c.column_name,  case when data_type = 'CHAR'     then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  

                          when data_type = 'VARCHAR'  then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'VARCHAR2' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NCHAR'    then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NUMBER' then    
                          case when c.data_precision is null and c.data_scale is null then          'NUMBER'
                          when c.data_precision is null and c.data_scale is not null then          'NUMBER(38,'||c.data_scale||')'
                              else           data_type||'('||c.data_precision||','||c.data_SCALE||')'      end  
                          when data_type = 'NVARCHAR' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NVARCHAR2' then     data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          else      data_type    end data_type,

                                decode(nullable,'Y','Yes','No') nullable,

                              c.DATA_DEFAULT,column_id,   com.comments

                                from sys.Dba_tab_Columns c,

                                     sys.Dba_col_comments com

                                where c.owner      = :OBJECT_OWNER

                                and  c.table_name =  :OBJECT_NAME 

                                and c.table_name = com.table_name

                                and c.owner = com.owner

                                and c.column_name = com.column_name

                                order by column_id

                          INFO8842oracle.dbtools.db.DBUtil$2Persisted settings for this table could not be loaded
                          INFO8837oracle.dbtools.db.DBUtil$2Modified SQL: select c.column_name,  case when data_type = 'CHAR'     then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'VARCHAR'  then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'VARCHAR2' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NCHAR'    then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NUMBER' then    
                          case when c.data_precision is null and c.data_scale is null then          'NUMBER'
                          when c.data_precision is null and c.data_scale is not null then          'NUMBER(38,'||c.data_scale||')'
                              else           data_type||'('||c.data_precision||','||c.data_SCALE||')'      end  
                          when data_type = 'NVARCHAR' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          when data_type = 'NVARCHAR2' then     data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'  
                          else      data_type    end data_type,

                                decode(nullable,'Y','Yes','No') nullable,

                              c.DATA_DEFAULT,column_id,   com.comments

                                from sys.Dba_tab_Columns c,

                                     sys.Dba_col_comments com

                                where c.owner      = :OBJECT_OWNER

                                and  c.table_name =  :OBJECT_NAME 

                                and c.table_name = com.table_name

                                and c.owner = com.owner

                                and c.column_name = com.column_name

                                order by column_id

                          FINER8820oracle.dbtools.db.DBUtil$2IOT_TYPE=null
                          FINER8810oracle.dbtools.db.DBUtil$2TYPE=TABLE
                          FINER8800oracle.dbtools.db.DBUtil$2LAST_DDL_TIME=2014-01-31
                          FINER8790oracle.dbtools.db.DBUtil$2TEMPORARY=N
                          FINER8780oracle.dbtools.db.DBUtil$2ID=284215
                          FINER8770oracle.dbtools.db.DBUtil$2CONNECTION_NAME=ING EP (TRUNK)
                          FINER8760oracle.dbtools.db.DBUtil$2COLUMN_NAME=null
                          FINER8750oracle.dbtools.db.DBUtil$2CATALOG=
                          FINER8740oracle.dbtools.db.DBUtil$2CHILD_NAME=null
                          FINER8730oracle.dbtools.db.DBUtil$2OBJECT_FOLDER_TYPE=TABLE
                          FINER8720oracle.dbtools.db.DBUtil$2PARTITIONED=NO
                          FINER8711oracle.dbtools.db.DBUtil$2CREATED=2014-01-31
                          FINER8700oracle.dbtools.db.DBUtil$2SHORT_NAME=null
                          FINER8690oracle.dbtools.db.DBUtil$2ConnectionType=Oracle
                          FINER8680oracle.dbtools.db.DBUtil$2OBJECT_ID=284215
                          FINER8670oracle.dbtools.db.DBUtil$2OBJECT_TYPE=TABLE
                          FINER8660oracle.dbtools.db.DBUtil$2GENERATED=N
                          FINER8650oracle.dbtools.db.DBUtil$2SCHEMA=EPP_OWNER_EPPL
                          FINER8640oracle.dbtools.db.DBUtil$2NAME=KV_INCASSO_METHODE
                          FINER8630oracle.dbtools.db.DBUtil$2EXTERNAL=N
                          FINER8620oracle.dbtools.db.DBUtil$2OBJECT_NAME=KV_INCASSO_METHODE
                          FINER8610oracle.dbtools.db.DBUtil$2OBJECT_OWNER=EPP_OWNER_EPPL
                          FINER8601oracle.dbtools.db.DBUtil$2DisplayResultTable.refresh(true)
                          FINER8590oracle.dbtools.raptor.controls.display.DisplayPanelDisplayPanel.Refresh(true} for Columns
                          FINER8581oracle.dbtools.raptor.controls.display.DisplayPanelDisplayPanel.Refresh()
                          FINE8571oracle.dbtools.raptor.controls.UIUtilsfinishIdeKeyBindingsProcessing: 1508068825oracle/dbtools/raptor/oviewer/base/accelerators.xml1
                          FINE8560oracle.dbtools.raptor.controls.UIUtilsstartIdeKeyBindingsProcessing: 1508068825oracle/dbtools/raptor/oviewer/base/accelerators.xml1
                          FINER8557oracle.dbtools.db.DBUtil$2DisplayResultTable.getUI()
                          FINER85439oracle.dbtools.raptor.controls.display.DisplayResultTableDisplayResultTable.getUI()
                          FINER853238oracle.dbtools.raptor.controls.display.DisplayPanelDisplayPanel.buildUI()
                          FINE8521oracle.dbtools.raptor.navigator.ObjectQueryInstanceElapsed Time: 23 ms
                          FINER85122oracle.dbtools.raptor.navigator.ObjectQueryInstanceLoaded: KV_INCASSO_METHODE
                          INFO8505520oracle.dbtools.db.DBUtil$10Prepared:

                          select * from (

                            SELECT o.OBJECT_NAME, o.OBJECT_ID ,'' short_name, decode(bitand(t.property, 32), 32, 'YES', 'NO') partitioned,

                                          decode(bitand(t.property, 64), 64, 'IOT',

                                         decode(bitand(t.property, 512), 512, 'IOT_OVERFLOW',

                                         decode(bitand(t.flags, 536870912), 536870912, 'IOT_MAPPING', null))) iot_type,

                                   o.OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, case when xt.obj# is null then 'N' else 'Y' end EXTERNAL

                              FROM SYS.Dba_OBJECTS O ,sys.tab$ t, sys.external_tab$ xt

                              WHERE O.OWNER = :SCHEMA

                              and   o.object_id = t.obj#(+)

                              and   o.object_id = xt.obj#(+)

                              AND O.OBJECT_TYPE = 'TABLE'

                          union all

                          SELECT OBJECT_NAME, OBJECT_ID , syn.SYNONYM_NAME short_NAME, decode(bitand(t.property, 32), 32, 'YES', 'NO') partitioned,

                                          decode(bitand(t.property, 64), 64, 'IOT',

                                         decode(bitand(t.property, 512), 512, 'IOT_OVERFLOW',

                                         decode(bitand(t.flags, 536870912), 536870912, 'IOT_MAPPING', null))) iot_type,

                                 SYN.TABLE_OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, case when xt.obj# is null then 'N' else 'Y' end EXTERNAL

                                        FROM SYS.Dba_OBJECTS O, sys.user_synonyms syn,sys.tab$ t, sys.external_tab$ xt

                                        WHERE  syn.table_owner = o.owner

                                        and    syn.TABLE_NAME = o.object_NAME

                                        and    o.object_id = t.obj#

                            and   o.object_id = xt.obj#(+)

                                        and    o.object_type = 'TABLE'

                                        and    :INCLUDE_SYNS = 1

                          )

                          WHERE OBJECT_NAME IN :NAME