Re: Obtaining DDL creation scripts from oracle

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 28 Jun 1999 19:23:20 GMT
Message-ID: <3780cb55.24812939@newshost.us.oracle.com>

A copy of this was sent to paulcinvt_at_aol.com (PaulCinVT) (if that email address didn't require changing) On 28 Jun 1999 19:07:18 GMT, you wrote:

[snip]

>And they would allow Functions in packages without Pragmas to compile...but so
>does Oracle's Procedure Builder :-)
>

can you elaborate on that? Whats wrong with allowing functions in packages without pragmas to compile? Its supposed to do that -- pragmas are 100% purely optional. You only need them if you intend to call the function directly from SQL (and in Oracle8i, release 8.1, you really don't even need them then anymore)..

>
>Paul in VT

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 28 1999 - 14:23:20 CDT