You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Empty utPLSQL windows when Show suites (hierarchical view of tests)? is unchecked #138
Hello
I installed the plug in in sql developer 20.4. The plugin worked fine, I tweaked some preferences and now I do not get any results anymore. Running ut.run works fine.
Reset to factory settings does not solve the problem.
I installed utplsql, played around with test_between_str, installed the plugin, generate a test package based on an existing package. Run utPLSQL test. That worked, after that I implemented some procedures and played with annotations like %disabled and %context. At some time I got this problem.
Ok, the utPLSQL tab looks strange. I have currently no idea how to reproduce this.
Could you please run the following in a SQL worksheet and provide the output?
set serveroutput on-- version information
declare
l_version varchar2(255);
l_compatibility varchar2(255);
begindbms_utility.db_version( l_version, l_compatibility );
dbms_output.put_line( l_version );
dbms_output.put_line( l_compatibility );
end;
/select substr(ut.version(),1,60) as ut_version from dual;
select*from v$version;
select*from nls_session_parameters;
select substr(dbms_utility.port_string,1,60) as port_string from dual;
-- test run
execute ut.run;
Furthermore, what happens when you close the utPLSQL window and run a test either from the editor or the Connections Window? Does it work? If yes, what are the excact steps to create such an empty utPLSQL window?
changed the title [-]Utplsql give no results[/-][+]Empty utPLSQL windows when `Show suites (hierarchical view of tests)?` is unchecked[/+]on Jul 12, 2021
Activity
eriktrip commentedon Jul 12, 2021
I tried on another device with sql developer 19.4 and there are no problems there
eriktrip commentedon Jul 12, 2021
I reinstalled utplsql and the proble has gone....
eriktrip commentedon Jul 12, 2021
The problem is back, on both devices.
Any help would be appreciated
PhilippSalvisberg commentedon Jul 12, 2021
Can you try "Reset Windows to Factory Settings"?
In case the problem occurs again. Could you please provide a step-by-step description to reproduce the problem? Thanks!
eriktrip commentedon Jul 12, 2021
Reset to factory settings does not solve the problem.
I installed utplsql, played around with test_between_str, installed the plugin, generate a test package based on an existing package. Run utPLSQL test. That worked, after that I implemented some procedures and played with annotations like %disabled and %context. At some time I got this problem.
Regards Erik

PhilippSalvisberg commentedon Jul 12, 2021
Ok, the utPLSQL tab looks strange. I have currently no idea how to reproduce this.
Could you please run the following in a SQL worksheet and provide the output?
Furthermore, what happens when you close the utPLSQL window and run a test either from the editor or the Connections Window? Does it work? If yes, what are the excact steps to create such an empty utPLSQL window?
PhilippSalvisberg commentedon Jul 12, 2021
I found the issue. It's a bug. Please make sure that
Show suites (hierarchical view of tests)?is checked in the utPLSQL preferences as shown below:Close the utPLSQL window. Then you can start a tests run and the window should be initialized properly.
You can switch the view within the GUI without problems.
[-]Utplsql give no results[/-][+]Empty utPLSQL windows when `Show suites (hierarchical view of tests)?` is unchecked[/+]eriktrip commentedon Jul 13, 2021
Thx!, that did the trick. I played around with those options.
Regards Erik
PhilippSalvisberg commentedon Jul 13, 2021
Keep issue open until the bug is fixed in the main branch.
fixes #138 - avoid exception during UI initialization, check if a row…
Merge pull request #148 from utPLSQL/bugfix/issue-138-empty-utplsql-w…