Database Utilities (MOSC)

MOSC Banner

I have a development database with one main schema and a bunch of developers who have their own data

edited Jun 8, 2016 5:05AM in Database Utilities (MOSC) 1 commentAnswered

What is the best way to set up this database so that the developer can unit test their code?

Here's the scenario:

there are public synonyms created for the objects in the main schema.

all of the stored objects have the AUTHID CURRENT_USER clause.

A developer copies a stored object into his/her own schema and modifies the code.  for the sake of this scenario, let's call this stored object, PKG1.

PKG1 can be called directly or it can be called by another stored object.  PKG1 will reference some other objects.

Currently, if PKG1 is called directly, it works.  But if PKG1 is called by another stored object which resided in the main schema, then it will call the PKG1 in the main schema, instead of the one in the developer's account.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center