Re: Extract packages using command line to VSS

nzpcmad wrote:
> Sorry, I wasn't clear enough.
>
> We know how to run command line commands to check-in to VSS.
>
> The problem we have is how to extract package DDL's via some kind of
> command line rather than a GUI e.g. via SQL Plus?
>
> Thanks
>
>
>
> DA Morgan wrote:

>> nzpcmad wrote:
>>> We use VSS as our code repository.
>>>
>>> At the moment, we use a GUI to manually extract the stored procedure
>>> packages and then manually check them into VSS.
>>>
>>> Is it possible to this via some kind of command line so the process can
>>> be made into a batch procedure?
>>>
>>> I looked at SQL Plus but couldn't see anything.
>>>
>>> Any ideas?
>>>
>>> Thanks
>> You will need to discuss this with Microsoft.
>> --
>> Daniel Morgan
>> University of Washington
>> Puget Sound Oracle Users Group

1. Please do not top post. Scroll to the bottom to reply.
2. Use the built-in DBMS_METADATA package. A demo of how to use it can be found in Morgan's Library at www.psoug.org. -- Daniel Morgan University of Washington Puget Sound Oracle Users Group