Re: Export/extract just Stored Procedures

use sqlplus and select against DBA_SOURCE. This should give you a start.

"Steve Sochacki" <steve.sochacki_at_eds.com> wrote:

>Is there anyway to export/extract just the stored procedures? We have a
>test database that is used for development and they're all in the same
>schema. The developers used to keep the stored procedure code in separate
>memebers, but I found that was not always the case. I need to move the
>'test' stored procedures to a model office database and can't think of any
>easy way to do it. As a relative newbie, any help would be appreciated.
>Thanks.

Mark Zawadzki, late of Waynesboro, Va.
'...there is not a sprig of grass that shoots uninteresting to me.'

                                                 Thomas Jefferson, 1790.