Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLT installation error with one package compilation error

2726106Nov 21 2014 — edited Nov 24 2014

hi, I need help with the SQLT installation.

I followed the instruction to download the SQLT and install it to the database, but getting the installation error on one package.

I look into it and nail down the particular package got compilation error SQLT$T, and tried login in as sqltxadmin user and compiled this package again but still getting compilation error. I use PL/SQL developer looking at this package but it seems we cannot look at the code of those procedures inside the packages, probably because it's proprietary codes and Oracle doesn't want us to see it.

So, I need help with this issue. any advice is really appreciated. thank you so much.

regards

Ryan

VALID   PACKAGE BODY 11.4.5.7 TRCA$T

VALID   PACKAGE BODY 11.4.5.0 TRCA$X

INVALID PACKAGE BODY 12.1.10 SQLT$T

DECLARE

*

ERROR at line 1:

ORA-20110: Invalid libraries: 1. Review sqcpkg.log.

ORA-06512: at line 11

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2014
Added on Nov 21 2014
6 comments
1,788 views