Separate files for Package Spec and Body

From: <billmil_at_my-deja.com>
Date: Fri, 03 Dec 1999 20:36:40 GMT
Message-ID: <8299ko$mn7$1@nnrp1.deja.com>

We're new to Oracle here and trying to adopt the best practices of the Oracle community. Do you Oracle experts prefer to define a package specification and body in separate source files or have both spec and body in one source file?

What are the pro's and con's of each approach?

Finally, do you have standard file extensions for Package specs and bodies (i.e. .pls and .plb)? I've seen a standards but don't know which ones are widely followed.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 03 1999 - 14:36:40 CST