copy package or procedure from one schema to another

[liu...@my-deja.com]

Hi there:
Does anybody know if there is a tool in Oracle that allows me to copy a
procedure or package from one schema to another? Help is appreciated.

Sent via Deja.com http://www.deja.com/
Before you buy.

[M. Armaghan Saqib]

Using my SQL PlusPlus (freeware), you can extract the procedure in SQL file
and execute this in other user/schema. e.g.

SQL> exec s.getpro('GIVE_RAISE','SCOTT')
| CREATE OR REPLACE
| procedure give_raise (
| p_deptno in number,
| p_raise_percent in number )
| as
| begin
| update emp set sal = sal + (sal * p_raise_percent * .01)
| where deptno = p_deptno;
|
| commit;
| end give_raise;
| /

regards,
M. Armaghan Saqib
+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL
| 3. Oracle CBT with sample GL Accounting System
| Download free: http://www.geocities.com/armaghan/
+---------------------------------------------------------------
<liu...@my-deja.com> wrote in message news:869u5u$49c$1...@nnrp1.deja.com...

------
Posted via news://freenews.netfront.net
Complaints to ne...@netfront.net

[DI Karl Heinz Hörmann]

liu...@my-deja.com schrieb in Nachricht <869u5u$49c$1...@nnrp1.deja.com>...

>Hi there:
>Does anybody know if there is a tool in Oracle that allows me to copy a
>procedure or package from one schema to another? Help is appreciated.

what do you want to do ?
is granting access insufficent ??

regards

[liu...@my-deja.com]

In article <86kfbd$1tq$1...@newsmaster01.magnet.at>,

If you want to package all the procedures a product requires to run in
a schema and to deploy that schema, merely granting access seems
insufficient. So if there is a tool that helps?