ORA-06550 Error executing SQL in debug session

[Ivan C.]

I have the following code in Test Window:

-- Created on 2013/03/08 by IC
declare
  -- Local variables here
  i integer;
begin
  -- Test statements here
  null;
end;

While in debug mode (F9):
1. Click "Execute SQL in debug session" button
2. Type the following code:

select count(*) from <schema>.[TABLE]

3. Click OK button

You get the result window. Now

4. Click "Execute SQL in debug session" button again
5. Modify the code to

select * from <schema>.[TABLE]

6. Click OK button

Get error ORA-06550: line 78, column 28:
PLS-00103: Encountered symbol "" when expecting one of the following:

This error is becoming a "Du jour" here, as many developers are getting the same.

IC

 

[Marco Kalter]

This scenario works fine for me.

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Ivan C.]

Greetings Marco,
I sent you an email with debug.txt, and was wondering if you had any updates on it.

Thanks.
IC

 

[Marco Kalter]

Not yet, we're looking into it.