This discussion is archived
3 Replies Latest reply: Jul 26, 2013 11:13 PM by v.plotnikov RSS

Sqldeveloper hangs on open PL/SQL debug window

v.plotnikov Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Pro
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points