search

utPLSQL / utPLSQL-PLSQL-Developer

utPLSQL Plugin for PL/SQL Developer
Apache License 2.0
26 stars 11 forks source link

utPLSQL is not installed #22

Closed VladDr85 closed 3 years ago

VladDr85 commented 3 years ago

Hi, utPLSQL is installed. The plugin is installed PlsqlDeveloperUtPlsqlPlugin.dll

I launch it via the context menu or via Tools->utPLSQL I get the error "utPLSQL is not installed"

it works:

select *
  from table(ut3.ut.run('ut_am.bout_block_calc_pkg'));

calc
  Between string function
    Returns substring from start position to end position [.002 sec]
    Returns substring when start position is zero [.002 sec]

Finished in .007329 seconds
2 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0 PL/SQL Developer 13.0.6.1911 (64 bit)

pesse commented 3 years ago

Hey @VladDr85 , does it work when you run it without the ut3 schema?

select * from table(ut.run('ut_am.bout_block_calc_pkg'));

If not I'd assume that you're missing the necessary public synonyms. (See http://utplsql.org/utPLSQL/latest/userguide/install.html#allowing-other-users-to-access-the-utplsql-framework)

VladDr85 commented 3 years ago

@pesse Thanks so much. it helped, everything works!

This solution fixed the problem https://github.com/utPLSQL/utPLSQL/issues/1097