3 Replies Latest reply: Jul 27, 2013 1:13 AM by v.plotnikov RSS

    Sqldeveloper hangs on open PL/SQL debug window

    v.plotnikov

      Hello!

      How to create a bug report for sqldeveloper?

      Version 4.0.0.12 have bug on debug pl/sql code (not for all packages).

      If I try to debug (ctrl+shift+10) pl/sql code after open body for one of my package body i have hang of sqldeveloper.

      All works normal if try to debug this package from specification.

      This output I can see in terminal window (If run sqldeveloper from terminal):

      ***** Syntactically Invalid code fragment *****

      >>>> syntactically invalid code fragment <<<<

      Syntax Error at line 3 862, column 10

       

       

       

       

        ( AgrID=>pagr,

                ^^^   

       

       

      Expected: '(','|',',',

      ***** Syntactically Invalid code fragment *****

      >>>> syntactically invalid code fragment <<<<

      Syntax Error at line 3 862, column 10

       

       

       

       

        ( AgrID=>pagr,

                ^^^   

       

       

      Expected: '(','|',',',

        • 1. Re: Sqldeveloper hangs on open PL/SQL debug window
          v.plotnikov

          I have found another issue for pl/debug.

          When I press OK button from debug pl/sql window for debug my code I get ORA-01017: invalid username/password; logon denied.

          I have password with special symbols and different cases for letters. No problems in sqldeveloper 3.

          • 2. Re: Sqldeveloper hangs on open PL/SQL debug window
            Vadim Tropashko-Oracle

            Bugged parser error as 17191776.

             

            Edit: I actually have trouble reproducing it. From your message I infer that there is syntax error at formal parameter assignment, yet the test

             

            create or replace PROCEDURE proc1 IS

            BEGIN

              dbms_output.put(a=>'OK');

            END proc1;

             

            runs (and debugs) fine. It must be that you have some other syntax that SQL developer parser doesn't recognize.

             

            Message was edited by: VadimTropashko

            • 3. Re: Sqldeveloper hangs on open PL/SQL debug window
              v.plotnikov

              with this sample I can get simular error, but sqldeveloper continue to work instead of hang.

               

              ***** Syntactically Invalid code fragment *****

              >>>> syntactically invalid code fragment <<<<

              Syntax Error at line 6, column 62

               

              CREATE OR REPLACE

              PACKAGE BODY DROPME AS

               

               

                procedure test_me AS

               

                cursor c1 is

                select a from (select dbms_report.store_file(component_name=>'a',filename=>'b',directory=>'c') a from dual ) ;

                BEGIN

                  -- TODO: Implementation required for procedure DROPME.test_me

                  NULL;

                END test_me;

               

               

              END DROPME;