Skip to content
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.

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

A warning when installing v3.1.1 #657

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
Labels
Milestone

Comments

@Mikhail5544
Copy link

@Mikhail5544 Mikhail5544 commented May 3, 2018

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 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 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

@Mikhail5544 Mikhail5544 commented May 4, 2018

@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 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

@Mikhail5544 Mikhail5544 commented May 4, 2018

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
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 self-assigned this May 5, 2018
@jgebal jgebal closed this in #661 May 7, 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
Labels
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants