Menu

#2 utconfig Prefix problem

Closed
nobody
2.2.2
11
2015-02-09
2014-08-13
Harbinder
No

Hello,
First of all, I love utplsql!

I learned about utplsql on my previous project. But they don't use it on my new project so I wanted to introduce it on my new project. I am trying to do setup and create some sample test packages. But the problem I am having is that most of our existing package names are already 30 character long. So when I run the test for any of those packages I get the below error. Is there any workaround for that? Please help. The error is:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SCHEMA.UTASSERT2", line 149
ORA-06512: at "SCHEMA.UTASSERT", line 49
ORA-06512: at "SCHEMA.UTPLSQL", line 426
ORA-06550: line 1, column 7:
PLS-00114: identifier 'UT_30_CHARACTER_PACKAGE_NAME' too long
ORA-06512: at "SCHEMA.UTPLSQL", line 929
ORA-06512: at "SCHEMA.UTPLSQL", line 1079
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SCHEMA.UTASSERT2", line 149
ORA-06512: at "SCHEMA.UTASSERT", line 49
ORA-06512: at "SCHEMA.UTPLSQL", line 426
ORA-06550: line 1, column 7:
PLS-00114: identifier 'UT_30_CHARACTER_PACKAGE_NAME' too long
ORA-06512: at line 1

Thanks,
Harbinder

Discussion

  • Svyatoslav Chatchenko

    You can place your test code directly inside your package. So you won't add prefix to package name. But in this case you have to add prefix to each individual test procedure/function inside your package. So you will have the same problem with individual procedures/functions names, if they also have "30 character" names.

     
  • Harbinder

    Harbinder - 2014-08-13

    Thanks much for quick reply! I was able to run the test package in the 'samepackage', I got the expected results, but I get this error on top of 'SUCCESS' or 'FAILURE' feed back. Please also explain what do I need setdir for ?

    Error UT-300005: Compile error: you must specify a directory with utConfig.setdir!
    Error compiling MY_TEST_PKG.pks located in "": ORA-20000: UT-300005: Compile error: you must specify a directory with utConfig.setdir!
    Please make sure the directory for utPLSQL is set by calling utConfig.setdir.
    Your test package must reside in this directory.
    Error UT-300005: Compile error: you must specify a directory with utConfig.setdir!
    Error compiling MY_TEST_PKG.pkb located in "": ORA-20000: UT-300005: Compile error: you must specify a directory with utConfig.setdir!
    Please make sure the directory for utPLSQL is set by calling utConfig.setdir.
    Your test package must reside in this directory.

     
  • Svyatoslav Chatchenko

    Please, look here: Auto compile feature
    You need to turn off autocompile.

     
  • Harbinder

    Harbinder - 2014-08-14

    Great! Thanks again!

     
  • Paul Walker

    Paul Walker - 2015-02-09
    • status: Open --> Closed
     

Log in to post a comment.

MongoDB Logo MongoDB