Use my freeware SQLPlusPlus to extract any stored source code (and
other objects DDL) to display, textfile or to database table.
regards,
M. Armaghan Saqib
- SQL PlusPlus : Add power to SQL Plus command line
- SQL Link for XL : Integrate Oracle with XL
- Oracle CBT with sample GL (Triggers and Forms Source Code included.
Download free: http://www.geocities.com/armaghan/
jason <jfielding_at_trinitech.co.uk> wrote in message
news:84t10n$m4v$1_at_trinitech.demon.co.uk...
> Hello + Happy New Year.
> I've been updating some Procs and Functions via Schema Manager 1.5,
but
> can't seem to find a good way of creating a file with these new /
improved
> functions / procs for our client. The Client already has the DB which
rules
> out doing a Full Export; I can't find a parameter to put in the param
file
> to export just the functions. I've also looked at reverse-engineering
the
> functions in Power Designer (6.1.0) - but can't get that working
either.
> The only way I've found is to select each function in Schema Manager
and
> copy the sql into a text file. Surely this is not the only way to do
this
> ??????
> Please Help.
> TIA
> Jason
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jan 05 2000 - 00:30:29 CST