Previous | Next
Topic: recompile problem
Conf: 537, Msg: 43053
From: Kevin Barnes (kevin.barnes@phocis.com)
Date: 5/21/01 05:43 AM

recompile problem Kevin Barnes malhamcove kevin.barnes@phocis.com Hi
I'm running 817 on redhat 7.2 and I have a problem when the tool recompiles the test package - as you'll see below. If the package is already loaded and the test is run without a compile it works fine - again see below. Any ideas?

SQL> exec utplsql.test('rds_user')
.
> FFFFFFF AA III L U U RRRRR EEEEEEE
> F A A I L U U R R E
> F A A I L U U R R E
> F A A I L U U R R E
> FFFF A A I L U U RRRRRR EEEE
> F AAAAAAAA I L U U R R E
> F A A I L U U R R E
> F A A I L U U R R E
> F A A III LLLLLLL UUU R R EEEEEEE
.
FAILURE: "rds_user"
.
: Unable to run ut_rds_user.ut_SETUP: ORA-06550: line 1, column 7:
PLS-00905: ob
ject RDS.UT_RDS_USER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement i
gnored
: utPLSQL.test failure: User-Defined Exception
BEGIN utplsql.test('rds_user'); END;

*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "UTPLSQL.UTASSERT", line 96
ORA-06512: at "UTPLSQL.UTPLSQL", line 344
ORA-06550: line 1, column 7:
PLS-00905: object RDS.UT_RDS_USER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "UTPLSQL.UTPLSQL", line 631
ORA-06512: at "UTPLSQL.UTPLSQL", line 695
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "UTPLSQL.UTASSERT", line 96
ORA-06512: at "UTPLSQL.UTPLSQL", line 344
ORA-06550: line 1, column 7:
PLS-00905: object RDS.UT_RDS_USER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at line 1


SQL> @ut_rds_user.pks

Package created.

SQL> @ut_rds_user.pkb

Package body created.

SQL> !ls
ut_rds_user.pkb ut_rds_user.pks

SQL> exec utplsql.test('rds_user',recompile_in=>FALSE)
.
> SSSS U U CCC CCC EEEEEEE SSSS SSSS
> S S U U C C C C E S S S S
> S U U C C C C E S S
> S U U C C E S S
> SSSS U U C C EEEE SSSS SSSS
> S U U C C E S S
> S U U C C C C E S S
> S S U U C C C C E S S S S
> SSSS UUU CCC CCC EEEEEEE SSSS SSSS
.
SUCCESS: "rds_user"
.

PL/SQL procedure successfully completed.

SQL>