Re: extract stored pl/sql pcode

Try http://www.benthicsoftware.com/downloads.html PL/Edit32 is the file you are looking for. This program allows you to load any PL/SQL from your database edit it, recompile, save to disk etc. One simple option is "quick export" which will create a script file to recreate ALL (ie: Functions/Procedures/Triggers/Packages/Views) PL/SQL in a schema.

Hope this helps.

PS. Golden is also wonderful for running any SQL. It has an extremely useful point and click schema view so that you get describes of your tables/views just by clicking on them, and just press Ctrl-P to get an explain plan, WONDERFULL. Regards,
Alexander Bisset.

"immo" <iwetzel_at_gmx.de> wrote in message news:86n33j$cqk$1_at_nnrp1.deja.com...
> Hello
>
> How can i extract some/all stored programm units so that i can it
> easy bring back into the database?
>
> Thanks
> Immo
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 31 2000 - 00:00:00 CET