Toad World® Forums

Question about SQL Navigator | Export Packages' DDL


How Do I export ALL my Packages in separate files, meaning, if I want to extract the DDL of ALL my procedures / “bulk Packages”, can I save header and body in a separate files?


Hi Diego,

Currently there is no option to separate the package spec and package body into 2 files. The best we can get is having each Package generate its spec and body into a file named as the packge name, by checking both options “New tab in the Code Editor for each object” and “Body and Spec for Packages/Objects” in Preferences | Extract DDL.