Menu

#5 Looking for u_teardown rather than ut_teardown

Pending-Confirmation
u_teardown (1)
2.3.0
10
2016-01-25
2015-06-30
No

Hello,

I'm trying to run a UT test by doing 'exec utplsql.test('SA_QPM_AIP_UNIV_FILTER_PKG');' but I get the following error:

Error at line 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "UTPLSQL.UTASSERT2", line 152
ORA-06512: at "UTPLSQL.UTASSERT", line 52
ORA-06512: at "UTPLSQL.UTPLSQL", line 426
ORA-06550: line 1, column 7:
PLS-00201: identifier 'U_SA_QPM_AIP_UNIV_FILTER_PKG.U_TEARDOWN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "UTPLSQL.UTPLSQL", line 929
ORA-06512: at "UTPLSQL.UTPLSQL", line 1079
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "UTPLSQL.UTASSERT2", line 152
ORA-06512: at "UTPLSQL.UTASSERT", line 52
ORA-06512: at "UTPLSQL.UTPLSQL", line 426
ORA-06550: line 1, column 7:
PLS-00201: identifier 'U_SA_QPM_AIP_UNIV_FILTER_PKG.U_SETUP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at line 1

I'm using Toad for Oracle and pressing both F5 and F9 produce this error. Help would be greatly appreciated!

Thanks,
Caitlin

Related

Support Archive (Use GitHub now): #5

Discussion

  • Paul Walker

    Paul Walker - 2015-06-30

    Looks like it's complaining that it can't find procedures called U_SETUP and U_TEARDOWN in your package U_SA_QPM_AIP_UNIV_FILTER_PKG. The default prefix is "UT_", not "U_". I'm wondering if it's been overridden by utConfig.setPrefix? (See if this page of the docs helps: utConfig Package: setPrefix)

     
  • Paul Walker

    Paul Walker - 2016-01-25
    • status: Open --> Pending-Confirmation
    • assigned_to: Paul Walker
     
    • Caitlin Cassidy

      Caitlin Cassidy - 2016-01-26

      I'm all set, thanks!

      On Mon, Jan 25, 2016 at 5:33 PM, Paul Walker p72endragon@users.sf.net
      wrote:

      • status: Open --> Pending-Confirmation
      • assigned_to: Paul Walker
      • Comment:

      Do you need any further help with this?

      Status: Pending-Confirmation
      Labels: u_teardown
      Created: Tue Jun 30, 2015 03:02 PM UTC by Caitlin Cassidy
      Last Updated: Tue Jun 30, 2015 09:25 PM UTC
      Owner: Paul Walker

      Hello,

      I'm trying to run a UT test by doing 'exec
      utplsql.test('SA_QPM_AIP_UNIV_FILTER_PKG');' but I get the following error:

      Error at line 1
      ORA-06510: PL/SQL: unhandled user-defined exception
      ORA-06512: at "UTPLSQL.UTASSERT2", line 152
      ORA-06512: at "UTPLSQL.UTASSERT", line 52
      ORA-06512: at "UTPLSQL.UTPLSQL", line 426
      ORA-06550: line 1, column 7:
      PLS-00201: identifier 'U_SA_QPM_AIP_UNIV_FILTER_PKG.U_TEARDOWN' must be
      declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      ORA-06512: at "UTPLSQL.UTPLSQL", line 929
      ORA-06512: at "UTPLSQL.UTPLSQL", line 1079
      ORA-06510: PL/SQL: unhandled user-defined exception
      ORA-06512: at "UTPLSQL.UTASSERT2", line 152
      ORA-06512: at "UTPLSQL.UTASSERT", line 52
      ORA-06512: at "UTPLSQL.UTPLSQL", line 426
      ORA-06550: line 1, column 7:
      PLS-00201: identifier 'U_SA_QPM_AIP_UNIV_FILTER_PKG.U_SETUP' must be
      declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      ORA-06512: at line 1

      I'm using Toad for Oracle and pressing both F5 and F9 produce this error.
      Help would be greatly appreciated!

      Thanks,
      Caitlin


      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/utplsql/support-tickets/5/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

      --
      Caitlin Cassidy
      Massachusetts Institute of Technology
      Department of Electrical Engineering and Computer Science | Class of 2018
      ccassidy@mit.edu | 781-801-9480

       

      Related

      Support Archive (Use GitHub now): #5

  • Paul Walker

    Paul Walker - 2016-01-25

    Do you need any further help with this?

     

Log in to post a comment.