SQL & PL/SQL

Hi!

I ran into quite difficult problem - have to create a package where the schema name has to be easily changed (find&repace is not an acceptable option). I'm not aware if there is possible to give an alias to schema (at least I haven't found a way yet).

I'm using schema name in type declarations and also in package body. Is it possible to use a variable in package (defined and initialized in package spec) containing the current schema name.

The idea is that the same package should be easily moved to another db where schema names differ (user_test -> user_prod).

Thanks a lot!