Skip to content

A warning when installing v3.1.1 #657

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
Mikhail5544 opened this issue May 3, 2018 · 5 comments
Closed

A warning when installing v3.1.1 #657

Mikhail5544 opened this issue May 3, 2018 · 5 comments
Assignees
@Pazus
Labels
bug
Milestone
v3.1.2

Comments

@Mikhail5544
Copy link

Hello,

There is one warning when we installing utPLSQL v 3.1.1. Could you fix it please?

Greate thanks.

[14:06:18][Step 2/2] --------------------------------------------------------------
[14:06:18][Step 2/2] Installing component UT_COMPOUND_DATA_HELPER
[14:06:18][Step 2/2]
[14:06:18][Step 2/2] Предупреждение: Пакет создан с ошибками компиляции. (Warning: The package was created with compilation errors)
@Pazus Pazus added the bug label May 3, 2018
@jgebal
Copy link
Member

jgebal commented May 4, 2018

Please provide the following:

  • steps you took to do the installation
  • database version
  • actual errors that show in package body after compilation

@Pazus
Copy link
Member

Pazus commented May 4, 2018

@Mikhail5544 Could you please check execute is granted on sys.dbms_crypto to the utPLSQL schema

@Mikhail5544
Copy link
Author

@jgebal Hello!

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
We lanched "install_headless.sql" script with default parameters.

  1. Grants on sys.dbms_crypto is OK
  2. Screenshot with Compilation errors for PACKAGE UT3.UT_COMPOUND_DATA_HELPER is attached.
    It's something with UT_DATA_VALUE_REFCURSOR

warning screenshot

Compilation errors for PACKAGE UT3.UT_COMPOUND_DATA_HELPER

Error: PLS-00201: идентификатор 'UT_DATA_VALUE_REFCURSOR' должен быть объявлен
Line: 60

@pocelka
Copy link

pocelka commented May 4, 2018

No issues on 11.2.0.3

Do you have UT_DATA_VALUE_REFCURSOR type compiled?

@Mikhail5544
Copy link
Author

As far as I understand the problem is:
Specification of UT_COMPOUND_DATA_HELPER installs earlier than ut_data_value_refcursor.tps and it uses that type.
pic2

Pazus added a commit to Pazus/utPLSQL that referenced this issue May 5, 2018
@Pazus
Fixed installation order to eliminate compilation error warning
629d3c7 
Removed ampersand symbol as some IDEs (PLSQL Developer) recognize it as a parameter to be defined
Removed unnecessary drop as ut_event_listener is already several lines before
Fixes utPLSQL#657
@Pazus Pazus mentioned this issue May 5, 2018
Merged
@Pazus Pazus self-assigned this May 5, 2018
@jgebal jgebal added this to the 3.1.2 milestone Jul 18, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Pazus Pazus

Labels
bug
Projects
None yet
Milestone
v3.1.2
Development

No branches or pull requests
4 participants
@jgebal @Pazus @Mikhail5544 @pocelka