4 Replies Latest reply on Jul 26, 2018 1:54 PM by GAson

Unit test repository error

GAson Jul 12, 2018 9:34 AM

Tried to setup Unit test for a try-out in "Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production"

First had som problem with "SYSDBA" issues after that created a repository but was not able to connect to it

Could see that some specific tables and package had been created, droped those objects but when I try to create a new repository

an error occur.

Any ideas wha's my problem??

Is there a way to "Drop repository" etc to be able to start over from scratch?

regards Gason

1. Re: Unit test repository error

thatJeffSmith-Oracle Jul 12, 2018 1:58 PM (in response to GAson)

I always use a dedicated schema for this, but you can also use Tools > Unit Test > Drop Repository
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Unit test repository error

GAson Jul 13, 2018 4:20 PM (in response to thatJeffSmith-Oracle)

Hi and thanks!
Yes I tried a dedicated UT schema but I think I messed up the "Manage Users".
I finally managed to create the "UT_REPOS" user and went on with the https://docs.oracle.com/cd/E15846_01/doc.21/e15222/unit_testing.htm#RPTUG45064
When running the test I get this error and I can't figure out why!! What have I done wrong (this time ;-)?
Regards Gunnar
Like Show 0 Likes(0)

Actions
3. Re: Unit test repository error

rp0428 Jul 16, 2018 5:21 PM (in response to GAson)

You have to SHOW US:

1. WHAT you do
2. HOW you do it
3. WHAT results you get

The tutorial link you provided has MANY steps in it - we have no idea if you did ANY of them, which ones you did, or whether you did them correctly.

SHOW US every step you did, the results of that step and that the procedure was created correctly.
Like Show 0 Likes(0)

Actions
4. Re: Unit test repository error

GAson Jul 26, 2018 1:54 PM (in response to rp0428)

"What I did?" I did wrong :-(
"HOW you do it" I created an HR package in HR schema, confusing the program (I'm ashamed)
" WHAT results you get" I took your time :-(
Sorry but thanks anyhow
regards GAson
Like Show 0 Likes(0)

Actions

Go to original post