Re: Moving a procedure from one scehma to another

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 08 Jan 2000 10:35:30 +0800
Message-ID: <3876A272.7E75@yahoo.com>

zris wrote:
>
> Can I move a procedure/package from one schema to another from with
> the QL/PL SQL?
>
> The schemas I create are dynamic and need access to a given set of
> procedures. Is there a way of transferring certain the procedure to
> the dynamically created schema?
>
> Chris

Use ALL_SOURCE to get the code and either use SQL Plus to re-compile in a new schema, or use DBMS_SQL (v7, 8.0) or execute_immediate (8i) to recompile using pl/sql.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 07 2000 - 20:35:30 CST