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>